Add SQL Prompt to SQL Management studio

Alex_197Alex_197 Posts: 4 Bronze 1
in SQL Prompt
Hi, I have a MS SQL Server 2008 R2 with installed prompt. All works fine.
I also installed SQL Server 2022 and Management Studio 20.

How to add Prompt to this Management Studio?

Thanks.
Tagged:
· Share on Twitter

Answers

  • Alex_197Alex_197 Posts: 4 Bronze 1
    I upgraded my prompt to version 14 as it was recommended in this forum,
    Prompt was added to the SSMS 20.1 but was removed from SSMS 2008 R2.

    Can I have Prompt in both SSMS?
    · Share on Twitter
  • Kurt_MKurt_M Posts: 209 Silver 1
    Hi @Alex_197

    Unfortunately, as of version 10.7, support for 2008 and 2008r2 was removed. Additionally, support for 2022 was being added from around 10.12. 

    Since SQL Prompt can't have multiple installs on the same machine, it's a bit tricky in your situation. Upgrading to 14 gives you support for 2022, but as you've noticed, it removes support for 2008r2. Your best bet here would be to install the version which supports the one you will be mainly using. You can use this link to download whichever version you need.

    Kind regards,

    Kurt McCormick
    Product Support Engineer, Redgate

    Need help? Take a look at our Help Center

    · Share on Twitter
Sign In or Register to comment.