What checks can be performed with dbcc?

Table 25-1 summarizes the checks performed by the dbcc commands. Table 25-2 compares the different dbcc commands.

**Table 25-1: Comparison of checks performed by **dbcc** commands**
Checks performed	checkstorage	checktable	checkdb	checkalloc	indexalloc	tablealloc	checkcatalog
Checks allocation of text valued columns	X
Checks index consistency		X	X
Checks index sort order		X	X
Checks OAM page entries	X	X	X		X	X
Checks page allocation	X			X	X	X
Checks page consistency	X	X	X
Checks pointer consistency	X	X	X
Checks system tables							X
Checks text column chains	X	X	X	X
Checks text valued columns	X	X	X

You can run all dbcc commands except dbrepair and checkdb with the fix option while the database is active.

Only the table owner can execute dbcc with the checktable, fix_text, or reindex keywords. Only the Database Owner can use the checkstorage, checkdb, checkcatalog, checkalloc, indexalloc, and tablealloc keywords. Only a System Administrator can use the dbrepair keyword.