Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Database Engine
Technical Reference
 sys.transmission_queue (Transact-SQ...

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
Other versions are also available for the following:
SQL Server 2008 Books Online (June 2009)
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.

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.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker