I downloaded SSMS 18.5, as there were a lot of fixes in here and thought this was a good upgrade to try. I’d heard reports of major changes in the VS shell causing issues with various add-ins, including Redgate tools, so I decided to verify things. Especially for SQL Prompt.
Tl;dr: The SQL Prompt fix is here: http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.1.4.14671.exe
As soon I installed this and started SSMS, the fun began.
This was all before the SSMS login. I connected to a database and SQL Prompt is definitely broken.
Fortunately, Redgate released a fix today, which you can download from http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.1.4.14671.exe
I downloaded that and ran the install. I also upgraded SQL Change Automation at the same time. After this, I restarted SSMS and Prompt now works.
Other fixes are on the way, as the teams are scrambling. This isn’t a big fix, but it is updating some things that changed as MS upgraded part of the shell.
The most important tool is now working. If you’ve never tried it, download SQL Prompt today and see how much faster you can write code.