Installed ssms 18.2, sql prompt not available. How to enable?

ejsejs Posts: 2 New member
edited August 13, 2019 1:44PM in SQL Prompt
Upgrades SSMS to 18.2 today and SQL Prompt not available.   Works fine under 17.n.

Same issue with SQL Search.  Attempting to install says "already installed":.
Tagged:

Answers

  • TomWTomW Cambridge Posts: 33 Bronze 4
    Hi @ejs

    Unfortunately, to get Redgate SSMS extensions to appear in SSMS 18 you'll need to uninstall and reinstall, after which they should appear.

    Please get in touch if you have any other issues.

    Thanks,

    Tom
    Team Prompt
  • JCitroJCitro OklahomaPosts: 3 New member
    Is the development team working on a fix for this?
  • ejsejs Posts: 2 New member
    edited August 20, 2019 9:45PM
    Uninstalling and reinstalling did do the trick.  Fortunately, it appears that my settings were preserved.

    Not terribly elegant but it works. 
  • TomWTomW Cambridge Posts: 33 Bronze 4
    Hi @ejs

    Glad to hear it worked for you. :)

    Yes, we're aware that it's not the most elegant solution but unfortunately we're constrained by how plugins for SSMS and Visual Studio are registered. If you upgrade to later versions of SSMS 18 you shouldn't have any issues.

    Thanks,

    Tom
    Team Prompt
  • JCitroJCitro OklahomaPosts: 3 New member
    After I updated SQL Prompt from 9.5.12 to 9.5.13 in SSMS 17, it became available in SSMS 18. This solution did not require me to uninstall SQL Prompt.
Sign In or Register to comment.