You created a Service Broker queue by using the following Transact-SQL 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 Transact-SQL 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);