How to get SQL Prompt to Appear in the SSMS 20

JArensdorf

I've installed SSMS version 20 and uninstalled SSMS version 18 and now I only have SQL Search showing in the toolbar for SSMS. I've uninstalled SQL Prompt multiple times and and did multiple repairs to the install as well and still I'm not getting sql prompt to show or run in SSMS.  

Any Suggestions??

TBurns

Same problem, downloaded latest version of SQL Prompt & installed, that did not help.  Assuming next version of SQL Prompt will fix this - running SSMS v19 in the meantime.

Schlote

I found this, looks like they are still working on it

https://productsupport.red-gate.com/hc/en-us/articles/17700853190045-SSMS-v20-and-your-Redgate-products

Tim_Robertson

Same problem, made it even worse because I had just received a new PC so installed latest version of SSMS and SQL Prompt doesn't work and I use is all day long on my work PC :-(

chrisqtran

Hello all,

Thank you for reaching out.

I can confirm that SQL Prompt is not yet compatible with SSMS v20. Our developers are actively working on getting these updates released soon. I will let you all know as soon as I have an update.

chrisqtran

Hi everyone,

I am happy to share that SQL Prompt is now available for SSMS 20. I've listed the installer for you to use:

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.11.7894.exe

 

Let me know how it works for you.

SkipSailors

I have SSMS 18 installed with SQL Prompt, and just installed SSMS 20.  When I run the installer listed above I get a message that SQL Prompt is already installed.  Is that expected?

robertr@tenaco.com

It's just dumb luck that I stumbled on this page and found this.  I was experiencing the same issues and looked to the product page to learn if perhaps SQL Prompt was not yet supported on SSMS20...  How could I be so stupid to think that a support business would admit that something was not working on the sales page of their product.  Thanks.

thatguy

I get the following error, even after repairing SSMS 20

chrisqtran

Hi @SkipSailors, 

You will have to uninstall, then reinstall SQL Prompt for it to connect to SSMS 20.

chrisqtran

Hi @thatguy

For the TextMgrP.dll error, can you follow these steps:
 
Close SSMS and/or Visual Studio
Open a Command Prompt as an administrator
Run the following command regsvr32 "C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Automation\TextMgrP.dll"
Open SSMS to test
 
And let me know how you get on.

**Edit: Previously, I forgot to add the file to the path. I have since changed it.

SupiluliumaII

chrisqtran said:

Hi @thatguy

For the TextMgrP.dll error, can you follow these steps:
 
Close SSMS and/or Visual Studio
Open a Command Prompt as an administrator
Run the following command regsvr32 "C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Automation"
Open SSMS to test
 
And let me know how you get on.

Hi!

same issue here.
Running the regsvr32 command fails with error message:

SupiluliumaII

This works though:

regsvr32 "C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Automation\TextMgrP.dll"

The error is gone now, thanks!

chrisqtran

My apologies, @SupiluliumaII.

Thank you for spotting my error! I've corrected it and can confirm that will work.

CCoker

If I uninstall SQL Prompt, will I lose the SQL History database?

I installed SSMS 20 today,  SSMS 18 was already installed on the same laptop with the latest SQL Prompt.  When I run the latest SQLToolbeltEssentials.exe file, it doesn't install any Redgate products in SSMS 20.  When I run the SQLPrompt_10.14.11.7894.exe installer recommended above, the installer displays a message that says a more recent version of SQL Prompt is already installed.  Based on earlier posts in this thread, I probably need to uninstall SQL Prompt, but I don't want to lose SQL History.

chrisqtran

Hi @CCoker

Uninstalling SQL Prompt won't delete your SQL History. All that information is stored in this folder:
C:\Users\<user>\AppData\Local\Red Gate\SQL Prompt 10

CCoker

@chrisqtran

Thanks!!! I uninstalled and reinstalled using the SQL Prompt installer you recommended on March 28, and it worked just great.  SQL History is still there, and when I opened SSMS 20 all the query tabs opened up that were open in SSMS 18 the last time I shut it down.