The nesting level for stored procedures in SQL S

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

(Continued from previous question...)

The nesting level for stored procedures in SQL Server 2005, but how many databases can you access inside one stored procedure?

Answer
8

Explanation
The footnote for nested stored procedures limits the number at 8.

(Continued on next question...)

Other Job Interview Questions

• Can a contained in SQL Server 2005 Integration Services enlist in a transaction started by a sibling container?
• Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?
• In SQL Server 2005, which network protocols use endpoints?
• To recover an instance of Notification Services in 2005 on another server, what information would you need?
• What is a dialog conversation in the SQL Server 2005 Service Broker.
• You wish to configure event logging for your SQL Server 2005 Notification Services instance. Where would you make this change?
• In replication, what is each set of the source data that is replicated from the source server called?
• If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
• How can you determine which user is executing statements in Profiler?
• Which of the following columns can be indexed with SQL Server 2005 Full-Text Search?
• More...