DBCC CHECKDB Checks integrity of all tables in the database. DBCC CHECKTABLE Checks integrity of the table. DBCC CHECKTABLE ("HumanResources.Employee") Options include: DBCC CHECKTABLE ("HumanResources.Employee") WITH PHYSICAL_ONLY - low overhread check recommended for large tables DBCC CHECKTABLE ("HumanResources.Employee") WITH TABLOCK - table becomes read-only while command is being run |