Loading ...

The SQL Server Service Broker for the current database is not enabled | CodeAsp.Net

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

 /5
0 (0votes)

While working with some application I was getting the following 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.

at following line: 

 System.Data.SqlClient.SqlDependency.Start(xxx

The solution was to enable the service from SSMS and the query was:

ALTER DATABASE [DBNAME] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE

Comments (no comments yet)

Top Posts