What is the use of DBCC commands?

Answer Posted / guest

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.

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why we need to use secondry database file? though, we can do same work using primary database file also.

6213


Explain throw statement in sql server 2008?

741


Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

808


Determine how to use the inserted and deleted pseudo tables?

730


Can a database be shrunk with users active?

802






Tell about MOM Tool(Microsoft Operator Manager)?

1598


What is 2nf in normalization?

748


How to replace null values in expressions using isnull()?

849


Explain external key management in sql server 2008

676


How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

786


What is an inner join?

710


What is attribute hierarchy? : sql server analysis services, ssas

713


What is the difference between local and global temporary tables?

792


How to sort the query output with order by clauses in ms sql server?

815


How to drop an existing table with "drop table" statements in ms sql server?

731