createtestdb.sql

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

USE master;
GO

IF EXISTS (SELECT * FROM sys.databases
           WHERE name = N'TargetDB')
     DROP DATABASE TargetDB;
GO
CREATE DATABASE TargetDB;
GO

IF EXISTS (SELECT * FROM sys.databases
           WHERE name = N'InitiatorDB')
     DROP DATABASE InitiatorDB;
GO
CREATE DATABASE InitiatorDB;
GO
ALTER DATABASE InitiatorDB SET TRUSTWORTHY ON;
GO

ALTER DATABASE InitiatorDB
      SET ENABLE_BROKER;
ALTER DATABASE TargetDB
      SET ENABLE_BROKER;