SQL SERVER – DBCC COMMANDS Category

What are DBCC Commands?

The DBCC commands acts as a Database Console commands for SQL Server. The DBCC commands are categorized into four.

 

Command Category Purpose
Maintenance Maintenance task on database,index & Filegroups
Miscellaneous* Miscellaneous tasks such as enabling trace flags or disabling a DLL from memory
Informational Task that gather and display various types of information.
Validation Validation Operation on database,table,index, filegroup or allocation of database pages.

The DBCC commands and examples will be continued.

print

Leave a Reply

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


1 + five =