I am using the following command to read from the queue. But it returns only one row. I noticed that conversation_handle is unique for all messages. How can I read top 100 or all the rows from the queue in sql server?
RECEIVE *-- @handle=conversation_handle, --@xml=CAST(message_body AS XML) FROM EventData_Destination_Queue
Have you tried:
Of course this may clear your queue and processing of messages wouldn't be possible.
I imagine in your example only the last message in the queue is displayed. The variables don't hold rowsets, just single values from a given row.
answered Aug 31, 2012 at 06:56 PM
Greg-- Thanks for your response. Yes I have tried it as well. But still I receive only one row from the query. This is the query I used
RECEIVE * FROM EventData_Destination_Queue
answered Aug 31, 2012 at 09:44 PM