SQL Server 2005 DBCC Command Reference

New, Undocumented and Retired DBCC Commands in SQL Server 2005

Microsoft’s SQL Server development team has introduced seven new DBCC commands. Unfortunately little or no documentation is available on the new commands listed below, though some of them may be documented in the RTM release.

Those that are listed as being documented do not require a trace flag to be set before using them. However, to use the undocumented commands, you will need to turn on trace flag 2588. This has changed since SQL Server 7.0/2000, where the trace flag was 2520.

Please note that the following is a result of investigations with the beta 2 release of SQL Server 2005, the final RTM release may differ slightly. As always, never use an undocumented DBCC command on a production server unless advised by Microsoft, and never use a documented one unless you understand how it may affect the performance of your server.

DBCC Commands New to SQL Server 2005

Documented New Commands

Undocumented New Commands

DBCC Commands Altered Since SQL Server 2000

The following is presented as a list of pairs of commands. The first command is the old syntax, as used in SQL Server 2000. The second of each pair is the altered syntax new to SQL Server 2005. In most cases the commands have been extended to take advantage of passing an object ID instead of a name, but if your scripts use any of these commands, it's probably worth checking them out before you migrate to SQL Sever 2005.

 

 

 

 

 

 

 

 

 

DBCC Commands Retired Since SQL Server 2000

Many of us have used them at one time or another and a few might even depend upon them. However, we can't say we have not been warned, and Microsoft has finally retired a whole raft of dbcc commands in SQL Server 2005. Most of these were not particularly useful, but thoughtfully retained right up to SQL Server 2000 for backward compatibility with SQL Server 6.5 and earlier scripts.

The following dbcc commands are now dead and buried from SQL Server 2005 onwards:

DBCC Commands Included in SQL Server 2005, which will be Retired at a Later Date

dbreindex
This will be replaced with the REBUILD option of the ALTER INDEX statement.

indexdefrag
This will be replaced with the REORGANIZE option of the ALTER INDEX statement.

showcontig
This command will be replace by the system function fn_indexinfo.

Complete List of Documented SQL Server 2005 DBCC Commands

Complete List of Undocumented SQL Server 2005 DBCC Commands

Acknowledgements and References

End of Essential Guide

SQL Server Club is a free community service from Norb Technologies - Making SQL Server Faster - www.norbtechnologies.com