I try to transfer messages from one service broker to second service broker. I want to get messages in order I send? but in fact I receive its in different order. Why it happens? I do it so:
DECLARE @conversationHandleXmlTransfer uniqueidentifier
DECLARE @conversationHandleXml uniqueidentifier
-- Start dialog.
BEGIN DIALOG @conversationHandleXml
FROM SERVICE [SourceService]
TO SERVICE 'TargetService'
ON CONTRACT [myconxml]
WITH ENCRYPTION = OFF;
-- Send message.
DECLARE @id int
SEND ON CONVERSATION @conversationHandleXml
MESSAGE TYPE [mymsg] (' ');
It woks. But when I send my messages once time again in other dialog, it receive in different order with messages that I receive the first time. Messages mix in two dialogs. I want to receive in order all my messages. How can I do this? Could I send my messages and indicate what dialog I want to use by sending?