Interested to Buy Any Domain ? << Click Here >> for more details...
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 the difference between resultset and resultsetmetadata?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What are database states in ms sql server?
How do you implement session management in SQL Server mode?
how many triggers you can have on a table? : Sql server database administration
What are the types of database recovery models?
Explain multiserver query
How to get the definition of a user defined function back?
What do you mean by sql server 2005 express management tools?
What are the advantages of the mirroring?
What is executereader?
What do you mean by subquery?
How to insert multiple rows with one insert statement in ms sql server?
Which command is used for user defined error messages?
What is implicit cursors?
