步骤一,查看:
sql数据库必须开启ServiceBroker服务,首先检测是否已经启用ServiceBroker,检测方法:
Select DATABASEpRoPERTYEX('dataBaseName ',‘IsBrokerEnabled’)
步骤二,设置:
ALTER DATABASE dataBaseName SET NEW_BROKER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE dataBaseName SET ENABLE_BROKER;
MSSQL SqlDependency
最新推荐文章于 2022-05-28 11:57:25 发布