How to get SQL Prompt to Appear in the SSMS 20
JArensdorf
Posts: 1 New member
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??
Any Suggestions??
Tagged:
Answers
https://productsupport.red-gate.com/hc/en-us/articles/17700853190045-SSMS-v20-and-your-Redgate-products
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.
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.
You will have to uninstall, then reinstall SQL Prompt for it to connect to SSMS 20.
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.
same issue here.
Running the regsvr32 command fails with error message:
regsvr32 "C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Automation\TextMgrP.dll"
The error is gone now, thanks!
Thank you for spotting my error! I've corrected it and can confirm that will work.
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.
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
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.
For your error message, could you try the suggestions in this article and see if the issue persists?
https://productsupport.red-gate.com/hc/en-us/articles/360019285638--Access-to-the-path-XXXX-is-denied-or-Object-reference-is-not-set-to-instance-of-an-object
Prompt was added to the SSMS 20.1 but was removed from SSMS 2008 R2.
Can I have Prompt in both SSMS?
SQL Prompt does allow for side-by-side SSMS installations, but the earliest version of SSMS that SQL Prompt 10 will support is SSMS 16.
Here are the requirements and supported platforms:
https://documentation.red-gate.com/sp/getting-started/requirements
I'm not familiar with SSMS 2008 R2, but you'll have to choose between using that version or SSMS 20 as SQL Prompt won't be compatible with both.
I am not getting any of the tools in the command bar.
Do I have to remove ssms 18 and reinstall the toolbelt for it to be compatible?
NVM, answer is here:
https://productsupport.red-gate.com/hc/en-us/articles/360003503274-SSMS-plug-ins-SQL-Prompt-SQL-Search-SQL-Source-Control-SQL-Test-are-missing-from-SSMS