创建接收库的消息服务.sql

来自「sql broker service 实例」· SQL 代码 · 共 22 行

USE TargetDB;
GO
CREATE MESSAGE TYPE [//BothDB/2DBSample/RequestMessage]
       VALIDATION = none;
CREATE MESSAGE TYPE [//BothDB/2DBSample/ReplyMessage]
       VALIDATION = none;
GO

CREATE CONTRACT [//BothDB/2DBSample/SimpleContract]
      ([//BothDB/2DBSample/RequestMessage]
         SENT BY INITIATOR,
       [//BothDB/2DBSample/ReplyMessage]
         SENT BY TARGET
      );
GO

CREATE QUEUE TargetQueue2DB;

CREATE SERVICE [//TgtDB/2DBSample/TargetService]
       ON QUEUE TargetQueue2DB
       ([//BothDB/2DBSample/SimpleContract]);
GO