Tools Reference (Database Engine)

Microsoft SQL Server 2008 includes a complete set of tools and command prompt utilities that allow users, programmers, and administrators to:

  • Administer and configure SQL Server.

  • Determine the catalog information in a copy of SQL Server.

  • Design and test queries for retrieving data.

  • Copy, import, export, and transform data.

  • Provide diagnostic information.

  • Start and stop SQL Server.

This section provides specific topics that describe the functionality of these tools.

Note

SQL Server 2008 Express includes the SQLCMD utility for the execution of Transact-SQL statement, and a limited version of the SQL Server Management Studio. Tools connect to SQL Server 2008 Express as a named instance.

In This Section