Removing SQL Server Management Studio Integration after uninstallation

Category: Troubleshooting & error messages
Date: 28 May 2009
Product: SQL Refactor
After uninstalling SQL Prompt and SQL refactor, SQL Server Management Studio can run so slowly as to be unusable.

Some elements of SQL Prompt and Refactor can be left behind after uninstallation. First, follow the procedures outlined here to fully remove the software:
  · http://www.red-gate.com/messageboard/viewtopic.php?t=7642&highlight=uninstall
  · http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Prompt&c=knowledgebase\SQL_Prompt\KB200708000116.htm

If SSMS still fails to perform adequately, the problem may be that SSMS is attempting to load the add-in after it has been uninstalled. Editing the registry by hand should fix this problem:

Navigate to the following path in the registry using the Windows Registry Editor (by typing 'regedit' in the run window):

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\PreloadAddinState\

If you find any registry values starting with "RedGate" in this key, follow these steps:
  · Delete the "RedGate" values.
  · Close the registry editor window
  · Run SqlWb.exe /setup to re-initialize Management Studio's interface
  · Check again by opening SSMS

This should fix the problem.