Uninstalling the Visual Studio 2005 add-in

Category: How do I?
Date: 16 Apr 2009
Product: SQL Prompt
Versions: 3.5-3.9
Platform: Microsoft Visual Studio 2005, any version of Microsoft Windows

SQL Prompt 3.5 and up 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:
  · Open Visual Studio 2005
  · Go to the Tools menu, then Options, then click 'add-in/macro security'
  · Click the add-in path to SQL Prompt 3 (c:\program files\red gate\sql prompt 3), then click remove
  · Exit VS 2005
  · Open the Visual Studio Command Prompt from the Visual Studio 2005 tools program group
  · Run devenv /resetaddin RedGate.SQLPrompt.VSUI.Connect
  · When VS2005 starts, right-click the menu bar and select Customize
  · 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 reinstalling SQL Prompt, or using the "'add-in/macro security'' option available through VS2005's Tools->options menu.

Document ID: KB200708000116 Keywords: SQL,Prompt,add-in,VS2005,Visual,Studio,2005,remove,uninstall

Was this article helpful?

Search support