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 |