Currently Processing Message in Que

[skg]

I have a stored proc. tied to a Queue activation. I use valid xml to
exchange information between queues.

Is there a way to know which message is being currently processed . ?

Currently i am writing a log when the stored proc is being called. I am
looking for a better way to query the system queues or conversation end
points.

advise

[Vargas@discussions.microsoft.com Luis Vargas]

Service Broker activation is agnostic of which messages is currently
processing.
A stored procedure is activated when a) there are new messages in a queue or
b) messages start accumulating in the queue.

The RECEIVE statement inside your store procedure could retrieve one, many,
or all the messages currently in the queue. The only way to keep track of
which message is being processed by a stored procedure is to manually log
some useful information about the message (e.g. an ID) within the transaction
that processes it.