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 coalesce in sql server?
What is outer join in sql server joins?
What is the use of RDBMS?
When to use Inner join & when to use subquery?
What is Cross Join and in which scenario do we use Cross Join?
What are Spatial data types in SQL Server 2008
Can foreign key be deleted?
How to define and use table alias names in ms sql server?
Do you know sql server 2008 backup compression?
What is policy management?
What are translations and its use? : sql server analysis services, ssas
What is create command?
When would you use a before or after trigger?
How to generate create function script on an existing function?
What is always encrypted?
