DBCC commands in SQL

Question

Hi Friends What is the use of DBCC commands in SQL ?

Satyapriya Nayak · Answer

Hi Manish DBCC stands for database consistency checker. We use these commands to check the consistency of the databases i.e. maintenance validation task and status checks. E.g. DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked. DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC CHECKFILEGROUP - Checks all tables file group for any damage. http://msdn.microsoft.com/en-us/library/aa258281%28v=sql.80%29.aspx Thanks

Sandeep Singh Shekhawat · Answer

DBCC stands for DataBase Consistency Checker. DBCC commands which are that are act as Database Console Command for SQL SERVER. DBCC command takes input parameters and return values. We use the DBCC Commands to check Consistency of database. This use for maintains validation tasks and status checks. For Example: DBCC CHECKDB To ensure tables in database and indexes are correctly related. There is all command : http://msdn.microsoft.com/en-us/library/ms188796.aspx