Posts

Showing posts from October, 2010

The SQL Server Service Broker for the current database is not enabled

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 if you wish to use notifications.

----Check if the service broker is enabled SELECT is_broker_enabled FROM sys.databases WHERE name = 'YOUR_DB' -- Enable broker ALTER DATABASE YOUR_DB SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE -- If fail above then new broker ALTER DATABASE YOUR_DB SET NEW_BROKER WITH ROLLBACK IMMEDIATE