Applies to: SQL Server (all supported versions)
Returns a row for each Service Broker message that an instance of SQL Server is in the process of forwarding.
|Column name||Data type||Description|
|conversation_id||uniqueidentifier||ID of the conversation to which this message belongs. NULLABLE.|
|is_initiator||bit||Indicates whether this message is from the initiator of the conversation. NULLABLE.
0 = Not from initiator
1 = From initiator
|to_service_name||nvarchar(512)||Name of the service to which this message is sent. NULLABLE.|
|to_broker_instance||nvarchar(512)||Identifier of the broker that hosts the service to which this message is sent. NULLABLE.|
|from_service_name||nvarchar(512)||Name of the service that this message is from. NULLABLE.|
|from_broker_instance||nvarchar(512)||Identifier of the broker that hosts the service that this message is from. NULLABLE.|
|adjacent_broker_address||nvarchar(512)||Network address to which this message is being sent. NULLABLE.|
|message_sequence_number||bigint||Sequence number of the message in the dialog box. NULLABLE.|
|message_fragment_number||int||If the dialog message is fragmented, this is the fragment number that this transport message contains. NULLABLE.|
|hops_remaining||tinyint||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.|
|time_to_live||int||Maximum time for the message to remain active. When this reaches 0, the message is discarded. NULLABLE.|
|time_consumed||int||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.|
|message_id||uniqueidentifier||ID of the message. NULLABLE.|
Requires VIEW SERVER STATE permission on the server.