使用SqlDependency时提示当前数据库未启用Service broker

解决办法:

ALTER DATABASE DatabaseName SET NEW_BROKER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE Databasename SET ENABLE_BROKER;

posted @ 2011-09-26 12:02  Hellen.Li  阅读(204)  评论(0编辑  收藏  举报