More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
In Service Broker for SQL Server 2005, you encounter the following setting in one of your queues...
In Service Broker for SQL Server 2005, you encounter the following setting in one of your queues.
RETENTION = ON
What does this mean?
Answer: This means that all messages in a conversation are retained in the queue until the conversation ends.
Explanation: This setting means that all messages on a conversation are retained in the queue until the conversations have ended. This allows for auditing or the ability to generate offsetting transactions. The default is off.
(Continued on next question...)