Applies To: SQL Server 2014, SQL Server 2016 Preview
Returns a row for each Service Broker message that an instance of SQL Server is in the process of forwarding.
Applies to: SQL Server (SQL Server 2008 through current version).
ID of the conversation to which this message belongs. NULLABLE.
Indicates whether this message is from the initiator of the conversation. NULLABLE.
0 = Not from initiator
1 = From initiator
Name of the service to which this message is sent. NULLABLE.
Identifier of the broker that hosts the service to which this message is sent. NULLABLE.
Name of the service that this message is from. NULLABLE.
Identifier of the broker that hosts the service that this message is from. NULLABLE.
Network address to which this message is being sent. NULLABLE.
Sequence number of the message in the dialog box. NULLABLE.
If the dialog message is fragmented, this is the fragment number that this transport message contains. NULLABLE.
Number of times the message may be retransmitted before reaching the final destination. Every time the message is forwarded, this number decreases by 1. NULLABLE.
Maximum time for the message to remain active. When this reaches 0, the message is discarded. NULLABLE.
Time that the message has already been active. Every time the message is forwarded, this number is increased by the time it has taken to forward the message. Not NULLABLE.
ID of the message. NULLABLE.
Requires VIEW SERVER STATE permission on the server.