SendMsgServiceBroker

CREATE PROCEDURE SendMsgServiceBroker
	@ProcedureName	VARCHAR(1000),
	@inserted		XML = NULL,
	@deleted		XML = NULL
AS
	SET NOCOUNT ON;

	DECLARE @msg XML

	-- build the XML message
	SET @msg = (SELECT
					ProcedureName	= @ProcedureName,
					inserted		= @inserted,
					deleted			= @deleted
				FOR XML PATH('Request'))

	DECLARE @DlgId UNIQUEIDENTIFIER

	BEGIN DIALOG @DlgId
		FROM SERVICE [//SMS_SB/InitiatorService]
		TO SERVICE '//SMS_SB/TargetService'
		ON CONTRACT [//SMS_SB/Contract]
	WITH ENCRYPTION = OFF;

	-- send the message
	SEND ON CONVERSATION @DlgId
	MESSAGE TYPE [//SMS_SB/Request] (@msg);


GO