Syntax DBCC CHECKDB [( 'database' | database_id | 0 [ , NOINDEX {REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD} )] [WITH { [ALL_ERRORMSGS ] [ , NO_INFOMSGS ] [ , TABLOCK ] [, ESTIMATEONLY ] [ , { PHYSICAL_ONLY | DATA_PURITY } ] } ] Key: NOINDEX - Skip intensive checks of nonclustered indexes for user tables REPAIR_ALLOW_DATA_LOSS - Try to repair all reported errors. REPAIR_REBUILD - Perform all repairs that can be performed without risk of data loss. ALL_ERRORMSGS - Return all reported errors per object, default = first 200 errors. TABLOCK - Obtain locks instead of using an internal database snapshot. this limits the checks that are performed. ESTIMATEONLY - Display the estimated amount of tempdb space that would be required. PHYSICAL_ONLY - Limits the checking to the integrity of the physical structure DATA_PURITY - Check the database for column values that are not valid or out-of-range.
-- Check the current database.
DBCC CHECKDB;
GO
"There are moments when everything goes well; don’t be frightened, it won’t last” ~ Jules Renard
Brian Cryer How To - Run DBCC checkdb on each database (using cursors)