Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.messages (Transact-SQL)

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 1 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.

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.