Use SQL Server Express to Remove a Tuning Database

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Use Microsoft SQL??Server 2005 Express Edition (SQL??Server Express) to remove a tuning database if a different version of Microsoft SQL??Server 2005 is not installed.

Remove an Empty Tuning Database

Use the sqlcmd utility from the command prompt to remove a tuning database. For more information about sqlcmd, see Using the sqlcmd Utility (SQL Server Express).

To remove a tuning database

1. If an instance of Microsoft Visual Studio 2005 connected to this database is running, exit that instance of Visual Studio 2005.

2. Open the command prompt window, and then locate the directory that contains sqlcmd.exe.

   By default, the path is %ProgramFiles%\Microsoft SQL??Server\90\Tools\Binn.

3. At the command prompt, type a command using the following syntax to connect to a SQL??Server Express server.

   sqlcmd -S myComputerName\SQLExpress
   

   Notice that the command prompt changes to a number one with an angle bracket (1>).

4. Use an SQL query to remove a database, for example:

   DROP DATABASE myTuningDB
   GO
   

5. Type QUIT to return to the command prompt window.

See Also

Other Resources

Management of Tuning Data
DROP DATABASE (Transact-SQL)