Optimization options not supported by some versions of SQL Server 2000 and SQL Server 2005

Introduction
Microsoft SQL Server 2005 Books Online does not correctly list the versions of SQL Server that the Database Engine Tuning Advisor graphical user interface (GUI) and dta utility support.

Note: The dta utility is the command prompt version of Database Engine Tuning Advisor.

The Database Engine Tuning Advisor GUI and dta utility can only be used to tune databases on the following versions of SQL Server:• SQL Server 2005 Developer Edition
• SQL Server 2005 Enterprise Edition
• SQL Server 2005 Enterprise Evaluation Edition
• SQL Server 2005 Standard Edition
• SQL Server 2000 Developer Edition
• SQL Server 2000 Enterprise Edition
• SQL Server 2000 Enterprise Evaluation Edition
• SQL Server 2000 Standard Edition
However, not all optimization options may be supported by SQL Server 2005 Standard Edition or SQL Server 2000 Edition.

More information
Optimization options not supported in SQL Server 2005 Standard Edition
SQL Server 2005 Standard Edition does not support optimization options including indexed views, partitioning, and generating online recommendations.

Optimization options not supported by SQL Server 2000
Optimization options involving partitioning and generating online recommendations are not supported in all editions of SQL Server 2000. Additionally, SQL Server 2000 Standard Edition does not support optimization options involving indexed views.

Unsupported optimization options details The following table lists the optimization options that are not supported by the Database Engine Tuning Advisor GUI.