如何在SQL Server 2005中使用Service Broker内部激活

CREATE PROCEDURE usp_SendSalesInfo

(
      @SaleDate SMALLDATETIME,
      @SaleAmount MONEY, 
      @ItemsSold INT

)

AS

BEGIN


      DECLARE @MessageBody XML
      CREATE TABLE #ProcParams
      (
            SaleDate SMALLDATETIME,
            SaleAmount MONEY,
            ItemsSold INT
      )
      INSERT INTO #ProcParams(SaleDate,SaleAmount, ItemsSold)
      VALUES(@SaleDate, @SaleAmount, @ItemsSold)


      SELECT @MessageBody = (SELECT * FROM #ProcParams FOR XML PATH ('Params'), TYPE);


      DECLARE @Handle UNIQUEIDENTIFIER;


      BEGIN DIALOG CONVERSATION @Handle
      FROM SERVICE [RecordSalesService]
      TO SERVICE 'SalesService'
      ON CONTRACT [SalesContract]
      WITH ENCRYPTION = OFF;


      SEND ON CONVERSATION @Handle 
      MESSAGE TYPE [RecordSale](@MessageBody);

END
GO