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

SQL Prompt for SSMS Pre-Release 20

Will Redgate SQL Prompt work on SSMS 20 Pre-Release released last week? If not when it's planned? Please inform.
NathanSundararajan
0

Comments

42 comments

  • johnniewalker
    chrisqtran said:

    Hi all,

     

    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.


    I installed the latest version of SQLPrompt (10.14.11.7894) but I do not see it in the Menu Bar of SSMS 20. It is in SSMS 19 though. Maybe I'm missing something.

    I did install SQL Search and it looks to be working.
    johnniewalker
    0
  • SupiluliumaII
    chrisqtran said:

    Hi all,

     

    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.

    Hi!

    I'm getting an error when starting SSMS 20 with SQL Prompt 10.14.11.7894:


    Transcript:
    SQL Prompt - error With TextMgrP.dll registration

    SQL Prompt has been disabled due to an error With the registration of a required DLL
    (TextMgrP.dll). To resolve the error, repair SQL Server Management Studio or Visual
    Studio from the Windows Control Panel.

    I followed the instructions and repaired both SSMS and VS but it did not fox the issue.
    I submitted an error report to redgate via the built in tool.
    SupiluliumaII
    0
  • mikecare
    Installed and working for me thanks for dropping today!
    mikecare
    0
  • DROP_TABLE_Students
    Thank you, Redgate.  SQL Prompt is now working with SSMS 20.

    Also, for anyone using Source Control, v7.7.9.18623 is working in SSMS 20.
    DROP_TABLE_Students
    0
  • wvaneldik
    Thanks for the solution
    wvaneldik
    0
  • SupiluliumaII
    Triple post
    SupiluliumaII
    0
  • SupiluliumaII
    Double post
    SupiluliumaII
    0
  • OmaCoder
    chrisqtran said:

    Hi all,

     

    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.

    Thank you!!

    I can't seem to get past this error, even after repairing SSMS 20.0. Any suggestions?

    SQL Prompt - error with TextMgrP.dll registration
    SQL Prompt has been disabled due to an error with the registration of a required DLL (TextMgrP.dll). To resolve the error, repair SQL Server Management Studio or Visual Studio from the Windows Control Panel.


    OmaCoder
    0
  • KevinCust
    chrisqtran said:

    Hi all,

     

    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.

    Not working for me.

    Fresh install of:

    * Windows 11 23H2 (build 22631.3374)
    * SSMS v20.0.70.0
    * SQL Prompt Pro v10.14.11.7894

    Error:

    SQL Prompt has been disabled due to an error with the registration of a required DLL (TextMgrP.dll). To resolve the error, repair SQL Server Management Studio or Visual Studio from the Windows Control Panel.

    KevinCust
    0
  • sinkee
    Open CMD as admin and type:
    regsvr32 "C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Automation\TextMgrP.dll"

    Reopen SSMS after this.

    sinkee
    0
  • chrisqtran

    Hi everyone,

    The developers have released the fix for this today. Please use the installer below and let me know how it works for you:

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

    chrisqtran
    0
  • johnniewalker
    chrisqtran said:

    Hi everyone,

    The developers have released the fix for this today. Please use the installer below and let me know how it works for you:

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

    Got this new version installed and now it is working properly in SSMS 20! Thank you!
    johnniewalker
    0

Add comment

Please sign in to leave a comment.