DBCC CHECKCATALOG performs various consistency tests between system metadata tables. If you run DBCC CHECKDB, you do not need to run DBCC CHECKCATALOG. For details of DBCC CHECKDB, please refer to “DBCC CHECKDB Command On SQL Server“.
You can do this operation on the database by using the following command. You should write your database name at the place where the test is written.
|
1 |
DBCC CHECKCATALOG ('Test'); |
As an important detail, this command cannot run in the tempdb database and the consistency of the filestream data is not checked with this command. You can find information about File Stream in my article “What is File Stream On SQL Server“.
