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 |
sysmessages clustered on error, dlevel
ncsysmessages nonclustered, unique on error, dlevel, langid
sp_addmessage | sp_droplanguage | sp_dropmessage |