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.

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.

See Also

Concepts