Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The

Undocumented DBCC Commands

The DBCC command originally exposed a small cadre of database maintenance routines that were outside the realm of traditional Transact-SQL. DBCC orga nized these routines into a versatile database administration Swiss army knife that DBAs used to manage routine maintenance and consistency checking.

Since then, DBCC's command verb list has grown to include dozens of things not related to database error checking. DBCC now handles everything from Profiler audit messages to database consistency checking to full-text index management. Many of the things DBCC can do are undocumented and are only called by Microsoft-supplied code. We'll talk about a few of them in a moment.

Before we delve into DBCC undocumented command verbs, ...