基于的异步消息的

该Stored Procedure负责从ReceivingQueue中检索消息，并根据Queue的Retention设置，来确定从Queue中移除消息或更新Queue中消息的状态。 2.设置目标队列（Target Queue）的激活机制 Use HelloWorldDBgoALTER QUEUE [ReceivingQueue] WITHACTIVATION (STATUS = ON, -- Turn on internal activationPROCEDURE_NAME = [HelloWorldResponder], -- Our stored procMAX_QUEUE_READERS = 4, -- Up to 4 concurrent readersEXECUTE AS SELF) -- Execute as user of incoming dialog

设置上述创建的Stored Procedure，该Stored Procedure将被激活并处理Queue中的消息。 3.在Initiator端发送消息 Use DotNetFun2goDECLARE @conversationHandle uniqueidentifierBEGIN TRANSACTION-- Begin a dialog to the Hello World ServiceBEGIN DIALOG @conversationHandleFROM SERVICE [SendingService]TO SERVICE \'ReceivingService\',\'a727462b-52eeee-d\'ON CONTRACT [XMLContract]WITH ENCRYPTION = OFF, LIFETIME = 600;-- Send messageSEND ON CONVERSATION @conversationHandleMESSAGE TYPE [XMLMessage](\'helloWelcome to Rickie Lee\'\'s blog, \');Select * From nversation_endpointsCOMMIT

同时日元币值高 其中，TO SERVICE \'ReceivingService\',\'a727462b-52eeee-d\'，’ReceivingSerice’表示目标Service名称，\'a727462b-52eeee-d\'则指定目标Service所在的数据库，可以通过如下SQL Script获取： -- Retrieve remote broker instance guidSELECT service_broker_guidFROM tabasesWHERE database_id = DB_ID(\'HelloWorldDB\')

另外，可以通过如下的SQL script来检测Initiator端收到的Reply消息： Select cast(message_body as XML) From SendingQueueReceive message_type_name,cast(message_body as XML)From SendingQueue

4.查询对话端点状态（State of Conversation Endpoints） 最后，可以通过在Target/Initiator端查询nversation_endpoints表，获取Dialog对话状态： Select * From nversation_endpoints