The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.
2023-09-27 14:21:30 时间
当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 时,
又出现另外一个警示:
解决方法是,Enable Service Broker on the database:
ALTER DATABASE [DataBase Name] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE
相关文章
- Do Visual Studio Database Project *.refactorlog Files Belong in Source Control?
- SQL Server 2012 copy database without data
- "The transaction log for database is full due to 'LOG_BACKUP'" in a shared host
- SQL Server: Database stuck in “Restoring” state
- sql server database mail
- how to backup and restore database of SQL Server
- 使用FMDB多线程訪问数据库,及database is locked的问题
- SQLiteDatabaseLockedException: database is locked (code 5): , while compiling: PRAGMA journal_mode
- web sql Database
- 解决报错(Could not create connection to database server.)
- CREATE DATABASE - 创建新数据库
- 转 LIST INCARNATION OF DATABASE
- 转 Logs are not shipped to the physical standby database
- Clone a Pluggable Database – 12c Edition
- Oracle Database PSU/CPU
- EM 12c: OMS Failed to start After restarting the Repository Database or reboot of the server
- Importing/Indexing database (MySQL or SQL Server) in Solr using Data Import Handler--转载
- zk 启动失败 报 “ Unable to load database on disk”