Service Broker基础应用(下）

复制-- 设置会话优先级--启用会话优先级选项ALTERDATABASE BookStore SET HONOR_BROKER_PRIORITY ON--启用会话优先级选项ALTERDATABASE BOOKDistribution SET HONOR_BROKER_PRIORITY ON--查看设置结果SELECT name,用下 is_honor_broker_priority_on FROM sys.databases WHERE name IN (BookStore, BookDistribution) /* name is_honor_broker_priority_on BookStore 1 BookDistribution 1 */USE BookStore GOCREATE BROKER PRIORITY Conv_Priority_BookOrderContract_BookOrderService FOR CONVERSATION SET (CONTRACT_NAME =[//SackConsulting/BookOrderContract],--特定的契约LOCAL_SERVICE_NAME =[//SackConsulting/BookOrderService],--本地服务REMOTE_SERVICE_NAME =ANY,--远程服务为ANY,即Service Broker端点的源码下载任何相关服务PRIORITY_LEVEL =10)--设置优先级为101.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.站群服务器