In my project i was trying to use
SqlDependency using this code.
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application
startup
// Register the default hubs route: ~/signalr
RouteTable.Routes.MapHubs(); System.Data.SqlClient.SqlDependency.Start(ConfigurationManager.ConnectionStrings["MindcrackerCMSConnectionString"].ConnectionString);
}
So I get this error message.
"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 not"
Solution
Start SQL Server and write this query to enable broker.
ALTER
DATABASE MindcrackerCMS
SET ENABLE_BROKER
WITH ROLLBACK
IMMEDIATE
To check weather broker is enable or not run this query.
SELECT
is_broker_enabled FROM
sys.databases
WHERE name =
'MindcrackerCMS'
To kill all the database running process, write this query.
USE
master
go
DECLARE
@dbname sysname
SET
@dbname =
'MindcrackerCMS'
DECLARE
@spid int
SELECT
@spid = min(spid)
from master.dbo.sysprocesses
where dbid
= db_id(@dbname)
WHILE
@spid IS NOT
NULL
BEGIN
EXECUTE
('KILL
'
+ @spid)
SELECT
@spid = min(spid)
from master.dbo.sysprocesses
where dbid
= db_id(@dbname)
AND spid > @spid
END
ALTER
DATABASE @dbname SET
ENABLE_BROKER
Note - MindcrackerCMS is my database name.