Post reply

not able to see messages in the queue

  • January 17, 2011 at 9:37 am

    #245539

    Hi 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 MyMessage

    VALIDATION = WELL_FORMED_XML;

    CREATE CONTRACT MyContract

    (MyMessage SENT BY ANY );

    CREATE QUEUE MySendingQueue

    WITH

    STATUS=ON

    ,RETENTION=OFF;

    CREATE QUEUE MyReceivingQueue

    WITH

    STATUS=ON

    ,RETENTION=OFF;

    CREATE SERVICE MySendingService

    ON QUEUE MySendingQueue

    (MyContract);

    CREATE SERVICE MyReceivingService

    ON QUEUE MyReceivingQueue

    (MyContract);

    DECLARE @handle uniqueidentifier

    BEGIN DIALOG CONVERSATION @handle

    FROM SERVICE MySendingService

    TO SERVICE 'MyReceivingService'

    ON CONTRACT MyContract;

    SEND ON CONVERSATION @handle

    MESSAGE TYPE MyMessage

    ('<message>hello world</message>')

    END CONVERSATION @handle

    SELECT * FROM dbo.MySendingQueue

  • January 23, 2011 at 9:23 am

    #1276978

    If 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply