ALTER DATABASE [DBNAME] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;;
ALTER DATABASE [DBNAME] SET TRUSTWORTHY ON
SELECT IS_BROKER_ENABLED,* FROM SYS.DATABASES WHERE DATABASE_ID=DB_ID()
结果为1 ,则说明已经开启服务
ALTER DATABASE [DBNAME] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;;
ALTER DATABASE [DBNAME] SET TRUSTWORTHY ON
SELECT IS_BROKER_ENABLED,* FROM SYS.DATABASES WHERE DATABASE_ID=DB_ID()
结果为1 ,则说明已经开启服务