创建调用发送消息的存储过程的触发器.sql

sql broker service 实例

USE [InitiatorDB]
if   exists   (select   *   from   dbo.sysobjects   where   id   =   object_id(N'[dbo].[InsertNewQuestion]')   and   OBJECTPROPERTY(id,   N'IsTrigger')   =   1)  
  drop   trigger   [dbo].[InsertNewQuestion]  
  GO  
   
   
  SET   QUOTED_IDENTIFIER   ON    
  GO  
  SET   ANSI_NULLS   ON    
  GO  
   
  CREATE   TRIGGER InsertNewQuestion   ON   dbo.SendTable
  FOR   INSERT  
  AS  
  exec SendMsg   
  GO  
  SET   QUOTED_IDENTIFIER   OFF    
  GO  
  SET   ANSI_NULLS   ON    
  GO  
    

insert into dbo.SendTable (Msg) values ('Test')