You created a Service Broker queue by using the following TransactSQL
statement:
CREATE QUEUE VacationRequestQueue
WITH
RETENTION = OFF,
ACTIVATION (
PROCEDURE_NAME = dbo.VacationRequestProcess,
MAX_QUEUE_READERS = 5,
EXECUTE AS SELF
);
You need to modify the Service Broker queue to prevent it from processing received messages. The
queue should continue to receive messages.
Which TransactSQL
statement should you use?
A.
ALTER QUEUE VacationRequestQueue
WITH
RETENTION = ON;
B.
ALTER QUEUE VacationRequestQueue
WITH
STATUS = OFF;
C.
ALTER QUEUE VacationRequestQueue
WITH
ACTIVATION (STATUS = OFF);
D.
ALTER QUEUE VacationRequestQueue
WITH
ACTIVATION (EXECUTE AS OWNER);