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

ejs · August 13, 2019 1:40PM

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":.

TomW · August 14, 2019 8:41AM

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

JCitro · August 20, 2019 9:36PM

Is the development team working on a fix for this?

ejs · 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.

TomW · August 21, 2019 8:30AM

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

JCitro · August 23, 2019 4:16PM

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.

TomW · August 27, 2019 8:20AM

Hi @JCitro

Yes, updating to a newer version of SQL Prompt when one becomes available will also do the trick. The "uninstall then reinstall" solution is just for customers who don't want to wait for the latest version of the product to get it to show up in SSMS 18.

Thanks,

Tom

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

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk