What message types exist in SQL Server 2005 Serv

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

(Continued from previous question...)

What message types exist in SQL Server 2005 Service Broker?

Answer
These are defined for each contract.
Explanation
Each application that sets up queues and contracts inside Service Broker must define the message types that are valid for the contract.

(Continued on next question...)

Other Job Interview Questions

• When declaring an XML document, which type allows text nodes at the top level?
• After you've completed a backup for your Sales server to disk...
• This administrator will own the jobs. Which role should you assign?
• When declaring an XML document, which type allows text nodes at the top level?
• When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?
• In SQL Server 2005, what permissions does a user need to successfully execute the USE command?
• The Sort component in SQL Server 2005 Integration Services is what type of component?
• What value should you use for the BROKER_INSTANCE parameter?
• What message types exist in SQL Server 2005 Service Broker?
• In SSIS, what is the difference between output columns and external columns?
• More...