Which commands are allowed when the "Ad Hoc Dist

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

(Continued from previous question...)

Which commands are allowed when the "Ad Hoc Distributed Queries" server option is set to 0 in SQL Server 2005?

Answer: OPENDATASOURCE calls

Explanation: This command allows the use of OPENROWSET and OPENDATASOURCE commands.

(Continued on next question...)

Other Job Interview Questions

• What does the ERROR_PROCEDURE() function return?
• What does the CREATE SERVICE statement do in SQL Server 2005?
• In SQL Server 2005 T-SQL, what does the CONTINUE statement do?
• How large a database can you have in this edition of SQL Server 2005? ...
• You are configuring a SQL Server 2005 Reporting Services instance for email delivery of reports. What are your options for delivering email?
• Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options?
• What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005?
• Where are Notification Services event messages logged in SQL Server 2005?
• What does CONTINUE do in T-SQL?
• What could be the problem if you know the service is working properly?
• More...