How to enable SQL Prompt for SSMS 19?

OffByOne

I have SSMS 18 and SQL Prompt 10.13.4 installed on my Windows 10 box.  SQL Prompt works great with SSMS 18.  I just installed SSMS 19 side by side with SSMS 18.  However, there is no SQL Prompt integration.  How do you get the SQL prompt integration working with SSMS 19 running side by side with SSMS 18?

Brad

Go to "Add or Remove Programs" in Windows. Find "SQL Prompt" and choose to uninstall (this will bring up a tool to either uninstall or repair), then repair the program. After this, it should be available in both versions; at least it was for me.

dkim1999

Hi @OffByOne ,

Thank you for reaching out about SQL Prompt.

As Brad said previously, uninstalling/reinstalling or repairing SQL Prompt should allow for use in both SSMS 18 and SSMS 19.

Kind Regards,

David K.

Product Support Engineer

kshan

Tried this and it fails with the error "SQL Prompt has been disabled due to an error with the registration of a required DLL (TxtMgrP.dll)". I've tried uninstalling and re-installing but to no effect. 

SQL Prompt: 10.13.7.360
SSMS: v19.0.2

MichaelMi

I am experiencing the same issue with SQL Prompt 10 when using SSMS v19.0.2 as above with TextPgr.dll registration.  

SQL Prompt has been disabled due to an error with the registration of a required DLL (TextMgrP.dll).


What gives?

kshan

This thread solved my issue

gilbertr2412

I've just had major troubles getting SQL Toolbelt (latest) to install.
Finally got what I needed extracted and did manual installs of SQL Prompt 10 via MSIEXEC.

SQL Prompt 10 is integrated with SSMS 18 but not SSMS 19 (latest)

alwaysbe23

Hey @gilbertr2412 - can you share the msiexec path you used that worked? Im struggling to get prompt on my ssms 19 (17 works fine)

gilbertr2412

Sorry - looks like link to article did not work, so let me try it again.

https://productsupport.red-gate.com/hc/en-us/articles/360007207454-Installing-from-the-msi-file-silent-install-

That should have everything you need.

ellerr

I am not getting any errors, but I've tried repairing and also uninstalling/installing the SQL Prompt 10, but I still cannot see any Redgate in my SSMS v19. It was only working in v18. Is there anything else I can try? I have SQL Prompt 10 v10.1.7

Thanks!