Export (0) Print
Expand All

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.

Community Additions

ADD
Show:
© 2014 Microsoft