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
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What is the difference between a "where" clause and a "having" clause?
what is a transaction and what are acid properties? : Sql server database administration
What do mean by xml datatype?
What is the contrast between sql and mysql?
How to modify existing triggers using "alter trigger"?
What protocol does sql server use?
What is the difference between cartesian product and cross join?
Explain primary key?
What are number line correlation administrators will use while working with a subquery?
Explain the difference between HTTP and HTTPS in database?
How to delete an existing row with delete statements in ms sql server?
What is the stuff?
What is the template in sql?
What is an expression in ms sql server?
