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

Easy fix for this common little error.

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

Simply Execute the following against the target DB

If the above statement results in an error try the following

Leave a Reply

Your email address will not be published. Required fields are marked *