Messages (for errors) Catalog Views - sys.messages
Applies to: SQL Server
Contains a row for each message_id or language_id of the error messages in the system, for both system-defined and user-defined messages. For more information, see sp_addmessage (Transact-SQL).
Column name | Data type | Description |
---|---|---|
message_id | int | ID of the message. Is unique across server. Message IDs less than 50000 are system messages. |
language_id | smallint | Language ID for which the text in text is used, as defined in syslanguages. This is unique for a specified message_id. |
severity | tinyint | Severity level of the message, between 0 and 25. This is the same for all message languages within a message_id. |
is_event_logged | bit | 1 = Message is event-logged when an error is raised. This is the same for all message languages within a message_id. |
text | nvarchar(2048) | Text of the message used when the corresponding language_id is active. |
Permissions
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
See Also
THROW (Transact-SQL)
Catalog Views (Transact-SQL)
Messages (for Errors) Catalog Views (Transact-SQL)
Exception Message Box Programming
Error Messages
Database Engine Events and Errors
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho