sys.dm_broker_forwarded_messages (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

Dynamic Management Views and Functions (Transact-SQL)
Service Broker Related Dynamic Management Views (Transact-SQL)