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

• You are building a .NET assembly that will access the registry of the local machine for a factor used in a computer column. What permission set should you assign it?
• Using Report Builder that is bundled with Reporting Services 2005, which of the following would work as a way to add a derived field to a report?
• What is the quickest way to get them working?
• You want to disable the receipt of messages in one of your databases by the Service Broken. How should you do this?
• The queries still seem slow immediately after snapshot creation. Why?
• Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report?
• You cannot remember what permissions that the db_accessadmin fixed database role has ...
• When declaring an XML document, which type allows text nodes at the top level?
• What else should you configure on these instances?
• Which of the following classes provide the context of the caller to SQLCLR Assemblies? Submitted by Michael Coles
• More...