How can we help you today? How can we help you today?

Announcement for SQL Prompt - SQL Prompt 11 is now out and supports SSMS 21 GA

Featured

SQL Prompt 11 is now available:

https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-11-0-release-notes

11.0.0.16715 - Released on 28th May 2025

Features

  • Added support for SQL Server Management Studio 21.
  • Added support for Synapse Dedicated SQL Pools.

 

Please note that there is a known issue with certain settings not being automatically copied over to the new version. We would suggest copying these settings manually from v10 folder to v11 folder by following below steps:

 

1. Copy contents of C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\CodeAnalysis to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\CodeAnalysis

 

2. Copy contents of C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ Snippets to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\ Snippets

 

3. Copy contents of C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ Styles to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\ Styles

 

4. Copy ConnectionColoringCategories.xml, ConnectionColoringServers.xml, RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml, RedGate_SqlPrompt_Engine_EngineOptions.xml files from C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\

 

Microsoft has aligned SSMS 21 UI to VS 2022. The SQL Prompt option now appears in the SSMS 21 Extensions menu:

Extensions
To move the SQL Prompt menu to the top-level menu, select Extensions | Customize Menu...
Then uncheck the checkbox next to the SQL Prompt item in the list.

Ben Patel
0

Comments

3 comments

  • Deco

    ssms21还是无法使用11.0.0.16715版本

    Deco
    0
  • Dmitriy

    Could someone please update the “Old Versions” page to add the most recent release of SQL Prompt v10? Currently the "Latest" link points to v11, and other links are v9 and below.

    Dmitriy
    0
  • Emory

    I'm still not able to get sql prompt to work in 21 GA. 

    Emory
    0

Add comment

Please sign in to leave a comment.