Category Archives: Service Broker

Enabling Service Broker on a database

To check the status of service broker on a database run the following (in the database)… SELECT is_broker_enabled FROM master.sys.databases WHERE database_id = DB_ID() If the broker is enabled it will return a 1, otherwise it will return 0. The … Continue reading

Posted in Service Broker | Comments Off on Enabling Service Broker on a database