DBCC CheckCatalog

Being day two of DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CHECKCATALOG.

Description:

DBCC CheckCatalog checks the catalog integrity for a given database. DBCC CheckCatalog is less intensive than DBCC CheckDB, as CheckCatalog checks that every data type in syscolumns has a matching entry in systypes and that every table and view in sysobjects has at least one column in syscolumns.

DBCC CHECKCATALOG Syntax

dbcc checkcatalog 
[
    ( { 'database_name' | database_id | 0 } )
]
    [ WITH NO_INFOMSGS ]

Example:

-- Check the current database.
DBCC CheckCatalog;

If there are no errors encountered you will see the following output:

If you encounter errors your can consider restoring from backup, or possibly using DBCC CheckDB with one of the repair options to attempt to fix the catalog corruption.

Notes:

For more information see TSQL Wiki DBCC checkcatalog.

DBCC Command month at SteveStedman.com is almost as much fun as shark week.

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!