SQL Prompt Error with TextMgrP.dll Registration

[gvar369]

Been getting this error when i start SSMS 2008 R2 or VS 2012.
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.

Please advise,

Thanks,
Vijay

[Anu Deshpande]

Many thanks for your post gvar369 and apologies for inconvenience caused.

For some unknown reason, SQL Server Management Studio installations have been unravelling and deleting the interface that Prompt need to get access to the query window.

Running this from a Command Prompt as administrator should fix it:

[gvar369]

Thanks Anuradha. Your solution worked. I had to make a small tweek to the command, to be able to execute on a 64-bit machine.
Instead of %commonprogramfiles% i had to specify the exact file location which was located in "program files x86" directory.


--
Vijay

[Anu Deshpande]

Thanks for the confirmation and I am glad that the solution worked.

I will make a note regarding the x86 folder.

Is there anything else I can help you with?
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com