SQL Server 2008 Books Online (October 2009)
SQL Server Administrative Tools

Starting with SQL Server 2005, several SQL Server 2000 administrative tools have been integrated into SQL Server Management Studio, several have been integrated into SQL Server Configuration Manager, and the Index Tuning Wizard has been renamed.

The following table maps SQL Server 2000 tools to their equivalents in SQL Server 2005:

SQL Server 2000 tool Current SQL Server tool

Query Analyzer

Code editor in SQL Server Management Studio. See Writing, Analyzing, and Editing Scripts with SQL Server Management Studio

Enterprise Manager

SQL Server Management Studio. See Introducing SQL Server Management Studio

Server Network Utility

SQL Server Configuration Manager

Client Network Utility

SQL Server Configuration Manager

Service Manager

SQL Server Configuration Manager

Index Tuning Wizard

Database Engine Tuning Advisor. See Differences Between Database Engine Tuning Advisor and Index Tuning Wizard

Using Current SQL Server Tools to Manage Previous SQL Server Versions

Starting with SQL Server 2005, tools use SMO and fully support the new features of SQL Server. SQL Server 7.0 and SQL Server 2000 tools use DMO and do not support the newer features of SQL Server.

  • SQL Server tools can manage SQL Server and all features of SQL Server 2000.
  • SQL Server 2000 tools cannot manage more recent versions.
  • Current SQL Server tools and SQL Server 2000 tools can both function normally installed on the same computer.
See Also

Concepts

Backward Compatibility with SQL Server 2000 Tools

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Page view tracker