sys.transmission_queue (Transact-SQL)
This catalog view contains a row for each message in the transmission queue, as shown in the following table:
Column name |
Data type |
Description |
|---|---|---|
conversation_handle |
uniqueidentifier |
Identifier for the conversation that this message belongs to. Not NULLABLE. |
to_service_name |
nvarchar(256) |
Name of the service that this message is to. NULLABLE. |
to_broker_instance |
nvarchar(128) |
Identifier of the broker that hosts the service that this message is to. NULLABLE. |
from_service_name |
nvarchar(256) |
Name of the service that this message is from. NULLABLE. |
service_contract_name |
nvarchar(256) |
Name of the contract that the conversation for this message follows. NULLABLE. |
enqueue_time |
datetime |
Time at which the message entered the queue. This value uses UTC regardless of the local time zone for the instance. Not NULLABLE. |
message_sequence_number |
bigint |
Sequence number of the message. Not NULLABLE. |
message_type_name |
nvarchar(256) |
Message type name for the message. NULLABLE. |
is_conversation_error |
bit |
Whether this message is an error message. 0 = Not an error message. 1 = Error message. Not NULLABLE. |
is_end_of_dialog |
bit |
Whether this message is an end of conversation message. Not NULLABLE. 0 = Not an end of conversation message. 1 = End of conversation message. Not NULLABLE. |
message_body |
varbinary(max) |
The body of this message. NULLABLE. |
transmission_status |
nvarchar(4000) |
The reason this message is on the queue. This is generally an error message explaining why sending the message failed. If this is blank, the message has not been sent yet. NULLABLE. |
priority |
tinyint |
The priority level that is assigned to this message. Not NULLABLE. |
Permissions
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.