Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

not able to see messages in the queue Expand / Collapse
Author
Message
Posted Monday, January 17, 2011 9:37 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, June 5, 2014 4:44 PM
Points: 484, Visits: 444
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
Post #1048828
Posted Sunday, January 23, 2011 9:23 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 5:56 AM
Points: 1,839, Visits: 3,421
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.
Post #1052062
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse