Which Transact-SQL 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 Transact-SQL 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 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);



Leave a Reply 0

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