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

7 comments

Sort by
  • Deco

    ssms21还是无法使用11.0.0.16715版本

    Deco
    -1
  • 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
  • Kundart

    Re: slope 2

    Great news! Always happy to see SQL Prompt getting updates. Thanks for keeping it evolving!

    Kundart
    -1
  • Bonnie Shepherd

    Re: geometry dash lite
    Hey everyone! Just saw the announcement for SQL Prompt 11 and I’m super excited about the new support for SSMS 21 GA. It’s great to see how Redgate is keeping up with the latest versions! I’m really curious about how integrating these updates will improve query writing efficiency. Has anyone had a chance to test it out yet? What specific features do you think will be game-changers in your daily work? Looking forward to hearing your thoughts!

    Bonnie Shepherd
    0
  • Emory

    LOL, New we're already on SSMS 22 at this point

    Emory
    0
  • Muzammil

    Necessary update.

    Muzammil
    0

Add comment

Please sign in to leave a comment.