SQL Prompt 3.5 and later ship with add-ins for SQL Server Management Studio, Query Analyzer, and Visual Studio 2005. The VS2005 add-in will allow intelligent code completion from inside Visual Studio when editing SQL files that are part of a database project. Since the SQL Prompt installer installs all add-ins automatically, it is necessary to remove SQL Prompt from Visual Studio 2005 manually after installation.

It is possible to disable only the Visual Studio 2005 add-in for SQL Prompt and leave the other add-ins intact. This must be done through Visual Studio 2005:

1.  Open Visual Studio 2005 
2.  Go to the Tools menu, then Options, then click 'add-in/macro security'
3.  Click the add-in path to SQL Prompt 3 (c:\program files\red gate\sql prompt 3), then click remove 
4.  Exit VS 2005 
5.  Open the Visual Studio Command Prompt from the Visual Studio 2005 tools program group
6.  Run devenv /resetaddin RedGate.SQLPrompt.VSUI.Connect 
7.  When VS2005 starts, right-click the menu bar and select Customize 
8.  Drag the 'ghosted' SQL Prompt menu off onto the customization Window

Visual Studio 2005 will no longer load the SQL Prompt add-in or automatically complete SQL code unless it is re-installed. This can be done by re-installing SQL Prompt, or using the "'add-in/macro security'' option available through VS2005's Tools > Options menu.