Updated: June 10, 2016
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:|
|xml_collection_id||int||For validation that uses an XML schema, the identifier for the schema collection used.|
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.