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.

截图如下：

解决方法：

参考上面的步骤，可以设置为True。
但是，你也许没有那么顺利，当你点击"OK"铵钮时，会现另外一个异常：

那怎样解决呢？没有关系，可以在SQL查询分析器中执行SQL语句：

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

DECLARE @DBName SYSNAMESET @DBName = 'Tutorial' --'Your DB Name'DECLARE @spid INTSELECT @spid = MIN(spid) FROM [MASTER].[dbo].[sysprocesses] WHERE dbid = DB_ID(@DBName)WHILE @spid IS NOT NULLBEGIN  EXECUTE ('KILL ' + @spid)  SELECT @spid = MIN(spid) FROM [MASTER].[dbo].[sysprocesses] WHERE dbid = DB_ID(@DBName) AND spid > @spidENDEXECUTE('ALTER DATABASE '+ @DBName +' SET ENABLE_BROKER')  --DISABLE_BROKER

Source Code

原标题：The SQL Server Service Broker for the current database is not enabled

关键词：sql