Hi Friends
What is the use of DBCC commands in SQL ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Nov 7, 2012, 9:16 PM
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 ShekhawatPosted Nov 7, 2012, 11:59 AM
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