sysmessages (master database only)

Contains one row for each system error or warning that can be returned by SQL Server. SQL Server displays the error description on the user's screen.

Column Datatype Description
error int Unique error number
severity smallint Severity level of the error
dlevel smallint Reserved. For internal use only.
description varchar(255) Explanation of the error with placeholders for parameters
langid smallint Language

Index

sysmessages clustered on error, dlevel

ncsysmessages nonclustered, unique on error, dlevel, langid

Referenced by Stored Procedures

sp_addmessage sp_droplanguage sp_dropmessage