-- set up:
USE master;
GO

ALTER DATABASE AdventureWorks2008R2
      SET ENABLE_BROKER;
GO

USE AdventureWorks2008R2;
GO

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'dyfnds65;sdf%h457!;'
GO

CREATE Message Type AWNewNotice VALIDATION = NONE; 
CREATE Message Type AWAck VALIDATION = NONE; 

CREATE CONTRACT NewNoticeContract 
 (AWNewNotice SENT BY ANY, AWAck SENT BY ANY );

CREATE QUEUE AWNewNoticeQueue; 
CREATE QUEUE AWAckQueue; 
 
CREATE SERVICE AWNewNoticeService ON QUEUE AWNewNoticeQueue; 
 
CREATE SERVICE AWAckService ON QUEUE AWAckQueue (NewNoticeContract);


-- send message:
DECLARE @dialog_handle uniqueidentifier,
        @XMLdata XML; 
 
SET @XMLdata = (SELECT * FROM sys.tables FOR XML AUTO); 
 
BEGIN DIALOG @dialog_handle 
FROM SERVICE AWNewNoticeService 
TO SERVICE 'AWAckService' 
ON CONTRACT NewNoticeContract;

SEND ON CONVERSATION @dialog_handle MESSAGE TYPE AWNewNotice(@XMLdata);

-- receive:
SELECT * FROM AWNewNoticeQueue;
 
DECLARE @dialog_handle UNIQUEIDENTIFIER, @XMLdata XML; 
 
RECEIVE TOP (1) @dialog_handle = conversation_handle,
 @XMLdata = message_body
 FROM AWNewNoticeQueue; 
 

SELECT @XMLData;