sys.service_message_types (Transact-SQL)

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

This catalog view contains a row per message type registered in the service broker.

Column name Data type Description
name sysname Name of message type, unique within the database. Not NULLABLE.
message_type_id int Identifier of the message type, unique within the database. Not NULLABLE.
principal_id int Identifier for the database principal that owns this message type. NULLABLE.
validation char(2) Validation done by Broker prior to sending messages of this type. Not NULLABLE. One of:

N = None

X = XML

E = Empty
validation_desc nvarchar(60) Description of the validation done by Broker prior to sending messages of this type. NULLABLE. One of:

NONE

XML

EMPTY
xml_collection_id int For validation that uses an XML schema, the identifier for the schema collection used.

Otherwise, NULL.

Permissions

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.