dbcc Checks

The dbcc commands hat you can run depend on your role.

For example:

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, textalloc, and tablealloc keywords.
Only a system administrator can use the dbrepair keyword.

Comparison of checks performed by dbcc commands
Checks Performed	checkstorage	checktable	checkdb	checkalloc	indexalloc	tablealloc	checkcatalog	textalloc
Allocation of text valued columns	X							X¹
Index consistency		X	X
Index sort order		X	X
OAM page entries	X	X	X	X	X	X		X
Page allocation	X			X	X	X		X
Page consistency	X	X	X
Pointer consistency	X	X	X
System tables							X	X²
Text column chains	X	X	X					X
Text valued columns	X	X	X					X³

¹textalloc does not check the allocation status for data pages holding columns, but does check the allocation status for text pages.

²textalloc checks the syspartition entry corresponding to the text or image column.

³ textalloc checks:

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