sys.service_message_types (Transact-SQL)

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. One of: N = None X = XML E = Empty Not NULLABLE.
validation_desc	nvarchar(60)	Description of the validation done by Broker prior to sending messages of this type. One of: NONE XML EMPTY NULLABLE.
xml_collection_id	int	For validation that uses an XML schema, the identifier for the schema collection used. Otherwise, NULL.

See Also