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?

Question

Accepted Answer

A. ALTER DATABASE Contoso SET NEW_BROKER;

Answer

B. ALTER DATABASE Contoso SET ENABLE_BROKER;

Answer

C. ALTER QUEUE VacationRequestQueue WITH STATUS = ON;

Answer

D. ALTER QUEUE VacationRequestQueue WITH ACTIVATION (STATUS = ON);

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…

Question

Options

How the community answered

Community Discussion