Tags » Service Broker » Page 2

The SQL Server Service Broker for the Current Database is not Enabled, and as a Result Query Notifications are not Supported. Please Enable the Service Broker for this Database

Start SQL Server and write this query to enable broker.

ALTER DATABASE Demo SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE
To check weather broker is enable or not run this query. 84 more words

SQL Server

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

To enable Service Broker run:

ALTER DATABASE  SET ENABLE_BROKER with rollback immediate;

To disable Service Broker:

ALTER DATABASE  SET DISABLE_BROKER;

To check if Service Broker is enabled on a SQL Server database: 15 more words

DataBase