Category Archives: Service Broker

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 inService Broker|Comments Off on Enabling Service Broker on a database