SQL Server Management Studio runs slowly after uninstalling SQL Prompt
Published 29 October 2019
After uninstalling SQL Prompt, SQL Server Management Studio can run more slowly than before. This may occur if SQL Server Management Studio attempts to load the add-in after it has been uninstalled.
To resolve this problem:
- Close SQL Server Management Studio.
- Open Registry Editor (regedit.exe).
- Navigate to the following registry key (where version is the SQL Server version): HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\<version>\Tools\Shell\PreloadAddinState
- Delete the RedGate.SQLPrompt.SSMSUI registry value.
- Close Registry Editor.
- Open a Command Prompt window and run
SqlWb.exe /setup
(SQL Server Management Studio 2005) orSSMS.exe /setup
(SQL Server Management Studio 2008, 2008 R2 and 2012) to re-initialize SQL Server Management Studio's interface.