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.
Feedback
https://aka.ms/ContentUserFeedback.
Binnenkort beschikbaar: In de loop van 2024 zullen we GitHub-problemen geleidelijk uitfaseren als het feedbackmechanisme voor inhoud en deze vervangen door een nieuw feedbacksysteem. Zie voor meer informatie:Feedback verzenden en weergeven voor