How can we help you today? How can we help you today?

How to enable SQL Prompt for SSMS 19?

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?


OffByOne
0

Comments

9 comments

Sort by
  • 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.
    Brad
    0
  • 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
    dkim1999
    0
  • 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


    kshan
    0
  • 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?


    MichaelMi
    0
  • kshan
    This thread solved my issue
    kshan
    0
  • 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)
    gilbertr2412
    0
  • 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)
    alwaysbe23
    0
  • 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.
    gilbertr2412
    0
  • 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!
    ellerr
    0

Add comment

Please sign in to leave a comment.