InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 08:13:45 GMT20http://www.sqlservercentral.com/Forums/Topic1048828-1281-1.aspxIf the message fails to be sent to the receiving service, you'll find it in sys.transmission_queue along with a error describing why it couldn't be sent.Sun, 23 Jan 2011 09:23:00 GMTNils Gustav Stråbøhttp://www.sqlservercentral.com/Forums/Topic1048828-1281-1.aspxHi guys,I created a queue as in the query below....but I am not able to see the messages in the queue...CREATE MESSAGE TYPE MyMessageVALIDATION = WELL_FORMED_XML;CREATE CONTRACT MyContract(MyMessage SENT BY ANY );CREATE QUEUE MySendingQueueWITHSTATUS=ON,RETENTION=OFF;CREATE QUEUE MyReceivingQueueWITHSTATUS=ON,RETENTION=OFF;CREATE SERVICE MySendingServiceON QUEUE MySendingQueue(MyContract);CREATE SERVICE MyReceivingServiceON QUEUE MyReceivingQueue(MyContract);DECLARE @handle uniqueidentifierBEGIN DIALOG CONVERSATION @handleFROM SERVICE MySendingServiceTO SERVICE 'MyReceivingService'ON CONTRACT MyContract;SEND ON CONVERSATION @handleMESSAGE TYPE MyMessage('<message>hello world</message>')END CONVERSATION @handle SELECT * FROM dbo.MySendingQueueMon, 17 Jan 2011 09:37:13 GMTSatishAyyar