You have a database named Contoso. The Contoso database has a Service Broker queue named VacationRequestQueue.
The Contoso database has been restored to a new server. Since restoring the database, Service Broker is no longer able to send new messages.
You need to configure Service Broker in order to resolve the issue.
Which Transact-SQL statement should you use?
A.
ALTER DATABASE Contoso SET NEW_BROKER;
B.
ALTER DATABASE Contoso SET ENABLE_BROKER;
C.
ALTER QUEUE VacationRequestQueue WITH STATUS = ON;
D.
ALTER QUEUE VacationRequestQueue WITH ACTIVATION (STATUS = ON);