You use Service Broker to manage data requests between SQL Server 2005 databases.
You need to make changes to objects for an existing service. You want to ensure that no messages can be received by the service until the changes are complete. What should you do?
A.
Create the queue with ACTIVATION STATUS OFF. Set it to ON when the service is ready.
B.
Create the queue with STATUS OFF. Set it to ON when the service is ready.
C.
Create the queue with only the queue_name argument. Set the other parameters when the service is ready.
D.
Create the queue with max_queue_readers = 0. Set it to an optimum value when the service is ready.
Explanation:
The STATUS clause determines whether the queue is enabled. When a queue is set to STATUS = OFF, it does not allow any messages to be added to or removed from the queue.