To install SQL Prompt, you must have administrator privileges. If you are upgrading from a previous version, the installer does all the preparation for you.

Running SQL Prompt

When you install SQL Prompt, add-ins to the following editors are automatically installed:

• SQL Server Management Studio
• SQL Server Management Studio Express Edition
• Query Analyzer
• Microsoft Visual Studio 2005 and 2008

Start any of these editors to begin using SQL Prompt. SQL Prompt features are available from the SQL Prompt menu:

Customizing SQL Prompt

You can customize how SQL Prompt suggests, inserts and formats your code, to more closely match the way you prefer to write queries. To change any of the default settings in SQL Prompt:

On the SQL Prompt menu, select Options.

See: Managing SQL Prompt behavior and Options for formatting your code.

Activating SQL Prompt

When your trial period expires, you need to enter your serial number to activate the product:

On the SQL Prompt menu, select Serial Number > Enter Serial Number.

Find out more about activation

Uninstalling SQL Prompt

To uninstall SQL Prompt, use the Windows Control Panel item, Add or Remove Programs or Programs and Features.

If the SQL Prompt menu item is not removed from SQL Server Management Studio or Visual Studio, see Removing SQL Prompt menu item after uninstalling.

Using SQL Prompt with Visual Studio

SQL Prompt can be integrated with Visual Studio 2005 and 2008. SQL Prompt only works in Database projects and SQL Server projects.

Using SQL Prompt with Query Analyzer

By default, SQL Prompt starts automatically whenever you start Query Analyzer. To switch off support for SQL Prompt in Query Analyzer, right-click the SQL Prompt 4 icon  in the desktop notification area and click Start SQL Prompt when you start Query Analyzer so that it is not ticked.

To remove the SQL Prompt 4 icon  from the notification area, right-click the icon and click Exit.

To add the SQL Prompt 4 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 Red Gate > SQL Prompt 4 menu, click SQL Prompt Query Analyzer Integration.