|
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
(comments are locked)
|
|
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.
(comments are locked)
|
|
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
(comments are locked)
|
Your answer
