﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / Administering / SQL Server 2005  / Sequence of message's transfer from one service broker to second service broker / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Sun, 19 May 2013 19:29:00 GMT</lastBuildDate><ttl>20</ttl><item><title>Sequence of message's transfer from one service broker to second service broker</title><link>http://www.sqlservercentral.com/Forums/Topic551090-146-1.aspx</link><description>Hello,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				BEGIN TRANSACTION										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					set @id=1					while(@id&amp;lt;=10)					begin					SEND ON CONVERSATION @conversationHandleXml					MESSAGE TYPE [mymsg] (' ');					set @id=@id+1;					end																							COMMIT 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?Thank you.</description><pubDate>Tue, 12 Aug 2008 09:04:09 GMT</pubDate><dc:creator>lyuch</dc:creator></item></channel></rss>