Which TransactSQL statement should you use?

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 TransactSQL
statement should you use?

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 TransactSQL
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);

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *