Sunday, 28 June 2015

How to enable, disable and check if Service Broker is enabled on a database?

SELECT name, is_broker_enabled FROM sys.databases

ALTER DATABASE test SET ENABLE_BROKER;

ALTER DATABASE test SET DISABLE_BROKER;

No comments:

Post a Comment