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?
Comments
9 comments
-
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.
-
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
-
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
-
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?
-
This thread solved my issue
-
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) -
Hey @gilbertr2412 - can you share the msiexec path you used that worked? Im struggling to get prompt on my ssms 19 (17 works fine)
-
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. -
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!
Add comment
Please sign in to leave a comment.