Installing SQL Prompt

To install SQL Prompt, your Windows® user must have administrator privileges.

If you have previously installed SQL Prompt 2, ensure that it is not running when you install and run SQL Prompt 3. To do this:

on the SQL Prompt menu, click Disable SQL Prompt
If SQL Prompt is already disabled, this menu option displays Enable SQL Prompt, and you do not need to click it.
or on the SQL Prompt Options dialog box, under SQL Prompt Availability, clear the Enable SQL Prompt check box
or right-click the SQL Prompt icon in the notification area of your Windows desktop, and click Exit

For details of how to uninstall SQL Prompt, see Uninstalling SQL Prompt.

SQL Prompt in SQL Server Management Studio

When you install SQL Prompt, add-ins to SQL Server Management Studio and SQL Server Management Studio Express Edition are automatically installed for you. The SQL Prompt features are available from the SQL Prompt menu.

SQL Prompt in Query Analyzer

The SQL Prompt 3 icon in the notification area of your Windows desktop is for Query Analyzer support. When you have installed SQL Prompt 3, SQL Prompt runs automatically whenever you start Query Analyzer.

To switch off support for SQL Prompt in Query Analyzer, right-click the SQL Prompt 3 icon in the notification area, and click Start SQL Prompt when you start Query Analyzer so that the menu item is not ticked; to switch on support for SQL Prompt, click Start SQL Prompt when you start Query Analyzer so that the menu item is ticked.

To remove the SQL Prompt icon from the notification area, right-click the SQL Prompt 3 icon, and click Exit; to add the SQL Prompt 3 icon so that you can switch on or switch off support for SQL Prompt with Query Analyzer, click the Windows Start menu, and on the SQL Prompt 3 menu, click SQL Prompt Query Analyzer Integration.

SQL Prompt in Visual Studio

When you install SQL Prompt, an add-in to Microsoft Visual Studio 2005 is automatically installed for you. The SQL Prompt features are available from the SQL Prompt menu.

Note that Visual Studio 2005 is supported only for standard database projects; Microsoft Visual Studio 2005 Team Edition for Database Professionals is not supported.