How to Enable Service Broker on SQL Server 2005 ?

You can check to see whether the Service Broker is enabled on your server by executing the following SQL syntax:

SELECT name, is_broker_enabled FROM sys.databases where name='YourDBName'

To enable the Service Broker on your database, you must execute the ALTER DATABASE command. The following SQL command will enable the Service Broker service on the your database:

ALTER DATABASE YourDBName SET ENABLE_BROKER