Home

How to Verify if Broker Services is enabled and how to enable it?

Submitted by admin on Thu, 04/22/2010 - 20:10
Posted in

How to check if Broker Service is enabled in SQL Server?

To Verify if the Broker Service is enabled on SQL Database, run the following Query:

select is_broker_enabled from sys.databases where name = '<yourdbname>'
If the value is set to 1, it means the Broker service is enabled.
By Default when you create a new database in SQL 2005, the Broker Service is enabled. But for whatever reason if it is disabled, you can enable it using the following Script.
use master
alter database <dbname> SET ENABLE_BROKER