Export (0) Print
Expand All

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

Applies to: SQL Server (SQL Server 2008 through current version).

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft