Can a contained in SQL Server 2005 Integration S

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

(Continued from previous question...)

Can a contained in SQL Server 2005 Integration Services enlist in a transaction started by a sibling container?

Answer: No
Explanation: Containers can only enlist in transactions started by a parent container, not a sibling container.

(Continued on next question...)

Other Job Interview Questions

• How many Service Packs will be released for SQL Server 2005 in 2007?
• Using Report Builder, which of the following statements is correct about formatting numbers?
• Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
• You are performing a number of SELECT queries on one of your SQL Server 2005 Service Broker queues and you get a call that applications using the queues are running slowly. What can you do?
• Which of the following services is instance-aware?
• In Full-Text Search, what is word breaking?
• What can tracer tokens measure in SQL Server 2005 transactional replication?
• Which of these is not a parameter you can pass to the LOGINPROPERTY function?
• When you install SQL Server 2005 and create a new database, is a Database Master Key created?
• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• More...