Installing SQL Prompt

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

Running SQL Prompt

If you have previously installed SQL Prompt 2, ensure that it is not running. When SQL Prompt 2 is running, the SQL Prompt icon is displayed in the notification area of your Windows desktop. To close SQL Prompt 2, right-click the icon, and click Exit.

You are not recommended to run SQL Prompt simultaneously in Query Analyzer and SQL Server Management Studio because the meta-data cache files are updated more frequently.

Running 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 Prompt when you start Query Analyzer so that the menu item is not ticked; to switch on support for SQL Prompt, click Start 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, click the Windows Start menu, and on the SQL Prompt 3 menu, click SQL Prompt Query Analyzer Integration.