If you are caching data using SQL Cache Dependency with the SqlCacheDependency parameter set to "CommandNotification", and then restore or detach/attach your database (say, during a deployment), you will likely see this 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."
This is caused by the fact that the service broker is disabled automatically during these operations. To re-enable it, you need to run the following:
ALTER DATABASE
YOUR_DATABASE
SET ENABLE_BROKER
Comments
|
On
1/8/2010
ankit
said:
Is there any other way to enable broker?
On
6/18/2009
vivek soni
said:
'Alter Database db SET Enable_broker' the command taking so much time in execting on the server connected in lan.......I am facing the same issue.....I closed the asp.net running site from the right bottom side of task bar.and closed all the connection to that database .......... query executes in seconds....
On
2/4/2009
nak
said:
query execution so much time because that database may be used other application or other user
On
7/16/2008
dave
said:
well u restart your pc and run query again. wll be 5 second. all does it need no db. connection n so taking much time.
On
4/25/2008
Sumit Rawat
said:
'Alter Database db SET Enable_broker' the command taking so much time in execting on the server connected in lan
|
Leave a Comment