Hi Friends
What is the use of DBCC commands?
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.
Jignesh TrivediPosted Feb 26, 2012, 10:37 PM
The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. These statements check the physical and logical consistency of a database. Many DBCC statements can fix detected problems.
please refer..
http://msdn.microsoft.com/en-us/library/aa258281%28v=sql.80%29.aspx
contain all DBCC command.
hope this help.
Satyapriya NayakPosted Feb 25, 2012, 5:37 AM
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.
Thanks