Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, February 5, 2016 9:16 PM
Points: 507, Visits: 498
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: Tuesday, January 26, 2016 8:35 AM
Points: 1,945, Visits: 3,552
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