sys.service_message_types (Transact-SQL)
Applies to: SQL Server
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: NONE XML EMPTY |
xml_collection_id | int | For validation that uses an XML schema, the identifier for the schema collection used. Otherwise, NULL. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
Atsauksmes
https://aka.ms/ContentUserFeedback.
Drīzumā: 2024. gada laikā mēs pakāpeniski pārtrauksim izmantot “GitHub problēmas” kā atsauksmju par saturu mehānismu un aizstāsim to ar jaunu atsauksmju sistēmu. Papildinformāciju skatiet:Iesniegt un skatīt atsauksmes par