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
Comments