首页
登录 | 注册

The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.

当Insus.NET尝试解决此问题《When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance.》http://www.cnblogs.com/insus/p/5622792.html 时,

又出现另外一个警示:
The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.

 
解决方法是,Enable Service Broker on the database:
The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.

 

The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.
The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.
ALTER DATABASE [DataBase Name] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE
Source Code

 


相关文章

  • Entity Framework Core in Action Entityframework Core in action是 Jon P smith 所著的关于Entityframework Core 书籍.原版地址. 是除了官方文档外另 ...
  • .NET Core Dapper操作mysql数据库
    前言 现在ORM盛行,市面上已经出现了N款不同的ORM套餐了.今天,我们不谈EF,也不聊神马黑马,就说说 Dapper.如何在.NET Core中使用Dapper操作Mysql数据库呢,让我们跟随镜头(手动下翻)一看究竟. 配置篇 俗话说得 ...
  • ASP.NET Core - 从Program和Startup开始
    Program 我们先看一下1.x和2.x的程序入口项的一个差异 1.x public class Program { public static void Main(string[] args) { var host = new WebH ...
  • 快三个月没写博客了,一直在忙着准备面试和去面试的路上,所以没时间写,也没什么想写的.现在告一段落,就总结一波! 面经 本人真的是双非一本.为什么加“真的”?因为有的人也写着"双非一本,进入阿里",但是某电子科技大学,比9 ...
  • 《k8s 源码分析》- Custom Controller 之 Informer
    Custom Controller 之 Informer 概述 架构概览 reflector - List & Watch API Server Reflector 对象 ListAndWatch watchHandler - ad ...
  • 学了很多乱七杂八的东西,但是依然停留在前端,在工作中一直和后端交流,但是不太了解数据库是怎么回事,为了加强学习,准备学习一些关于数据库相关的东西. 说起数据库可能会有很多很多,SQLServer.Oracle.Sybase等等等,还有就是要 ...

2020 cecdns.com webmaster#cecdns.com
12 q. 0.077 s.
京ICP备10005923号