SQL Server Administrative Tools
In 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 | SQL Server 2005 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 |
|
Client Network Utility |
|
Service Manager |
|
Index Tuning Wizard |
Database Engine Tuning Advisor. See Differences Between Database Engine Tuning Advisor and Index Tuning Wizard |
Using SQL Server 2005 Tools to Manage Previous SQL Server Versions
SQL Server 2005 tools use SMO and fully support the new features of SQL Server 2005. SQL Server 7.0 and SQL Server 2000 tools use DMO and do not support the new features of SQL Server 2005.
- SQL Server 2005 tools can manage SQL Server 2005 and all features of SQL Server 2000.
- SQL Server 2000 tools cannot manage SQL Server 2005.
- SQL Server 2005 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