Description: thefrozencoder - Programming and Technology blog - Programming and Technology blog
web hosting (232708) hardware (6801) articles (4403) general (2956) sql server (675) developer tools (103) knowledgebase (39) it - software (37) it - technology (28) code development (3)
When uninstalling SSMS v18 and installing the latest SSMS v19.0.2 with SQL Prompt installed you may get the following error when running SSMS for the first time.
"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."
Running a repair will not fix the issue. This is because the dll TextMgrP.dll is not located in the shared x86 location it used to be in prior to v19 as it's now a x64 assembly. To fix this error you now need to register the x86 version in a different location. The old location was in "C:\Program Files (x86)\Microsoft Shared\MSEnv"