DBA > Job Interview Questions > Microsoft SQL Server FAQs

What does this method in SQL Server 2005's SMO e

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does this method in SQL Server 2005's SMO equate to in T-SQL?
db.CheckTables(RepairType.None)

Answer
DBCC CHECKDB WITH NO_INFOMSGS

Explanation
This SMO method executes a DBCC CHECKDB with the NO_INFOMSGS option set.

(Continued on next question...)

Other Job Interview Questions