Answer Posted / sanjeev kumar
DBCC stands for database consistency checker. We use these
commands to check the consistency of the databases.
Example, maintenance, validation task and status
checks.Saying is that,through DBCC we can check what is
happining in database on time to time. It give me a changes
of information just happing in a bit of time (this is the
reason it is called consistency)
like:-
DBCC CHECKALLOC - Check consistency of disk allocation.
DBCC CHECKCATALOG - Check catalog consistency
DBCC CHECKCONSTRAINTS - Check integrity of table constraints.
etc.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is a dataset and what are the different types of datasets?
What purpose does the model database server?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How to use transact-sql statements to access the database engine?
What is a join in sql? What are the types of joins?
In which format does an image save in SQL Server database ?
What were the latest updates to SQL Azure service?
Can the “if update (colname)” statement be used in a delete trigger?
What are ddl triggers and types of ddl trigger?
Is truncate a dml command?
System requirements for sql server 2005 express edition?
How can you stop stored procedures from recompiling?
What is report snapshot?
What is dynamic cursor in SQL SERVER?
Is null vs coalesce?
