After uninstalling SQL Refactor, SQL Server Management Studio can run so slowly as to be unusable.

Cause

Some elements of SQL Prompt and Refactor can be left behind after uninstallation

How to fix

Follow the steps described in Uninstalling SQL Refactor to fully uninstall the program.

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:

1. 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\

   
   

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

This should fix the problem.

If you continue to experience problems, please contact Red Gate Support.