DBCC CheckCatalog

Download PDF

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:
dbcc_catalog1

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

Time limit is exhausted. Please reload CAPTCHA.