DBCC CHECKALLOC - Check consistency of disk allocation. DBCC CHECKCATALOG - Check catalog consistency DBCC CHECKCONSTRAINTS - Check integrity of table constraints. DBCC CHECKDB - Check allocation, and integrity of all objects. DBCC CHECKFILEGROUP - Check all tables and indexed views in a filegroup. DBCC CHECKIDENT - Check identity value for a table. DBCC CHECKTABLE - Check integrity of a table or indexed view. DBCC CLEANTABLE - Reclaim space from dropped variable-length columns.
"The supreme quality for leadership is unquestionably integrity. Without it, no real success is possible, no matter whether it is on a section gang, a football field, in an army, or in an office" ~ Lucille Ball