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

Other Resources

Conversation Architecture

Help and Information

Getting SQL Server 2005 Assistance