Activity overview
Latest activity by SupiluliumaII
Double post / comments
Double post
Triple post / comments
Triple post
This works though: regsvr32 "C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Automation\TextMgrP.dll" The error is gone now, thanks! / comments
This works though:regsvr32 "C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Automation\TextMgrP.dll"The error is gone now, thanks!
chrisqtran said:
Hi @thatguy 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" Open SSMS to test And let me know how you get on.
Hi! same issue here. Running the regsvr32 command fails with error message: [image] / comments
chrisqtran said:
Hi @thatguyFor the TextMgrP.dll error, can you follow these steps: Close SSMS and/or Visual StudioOpen a Command Prompt as an administratorRun the following command regsvr32 ...
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: [image] 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. / comments
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...
NathWilson said:
We released a fix for this today in SQL Prompt v10.6.16.
Thanks for the fix, works for me too! 🙂 / comments
NathWilson said:
We released a fix for this today in SQL Prompt v10.6.16.
Thanks for the fix, works for me too! 🙂
Same SQL Prompt version, same SSMS version. For me, the error does not occur immediately upon typing "@" though, but after selecting a table variable from the SQL prompt suggestions box. E.g.
Type "INSERT INTO @"
Select @tvp from the suggestions
Crash
/ comments
Same SQL Prompt version, same SSMS version. For me, the error does not occur immediately upon typing "@" though, but after selecting a table variable from the SQL prompt suggestions box. E.g.
Type...
FYI, they fixed this in version 9.5.20.11737. https://documentation.red-gate.com/sp9/release-notes-and-other-versions/sql-prompt-9-5-release-notes#SQLPrompt9.5releasenotes-9.5.20.11737 Thanks Redgate! [image] / comments
FYI, they fixed this in version 9.5.20.11737.https://documentation.red-gate.com/sp9/release-notes-and-other-versions/sql-prompt-9-5-release-notes#SQLPrompt9.5releasenotes-9.5.20.11737Thanks Redgate!
Jessica R said:
@SupiluliumaII, if you have a supported license please feel free to open a ticket as well b y emailing support@red-gate.com. Otherwise, I'll update here once we know more.
@Jessica R, thanks for the suggestion, I will do that. / comments
Jessica R said:
@SupiluliumaII, if you have a supported license please feel free to open a ticket as well b y emailing support@red-gate.com. Otherwise, I'll update here once we know more.
@Je...
Jessica R said:
Sorry to hear you're both still running into this! To help us narrow down where things are going wrong, can I just confirm: - Does this fail for every synonym? - Does it fail in every query, even a simple one that calls on the synonym?
bmrazik said:
yes, all synonyms no matter the query...you'll see above as well, that i lose peeking at index definitions on indexed views
Same here. I see no synonyms at all in suggestions, even in very simple queries. Peeking at synonyms' definitions does not work either. / comments
Jessica R said:
Sorry to hear you're both still running into this!To help us narrow down where things are going wrong, can I just confirm:- Does this fail for every synonym?- Does it fail in ...