sysmessages (T-SQL)

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

Column name Data type Description
error int Unique error number.
severity smallint Severity level of the error.
dlevel smallint Reserved. For internal use only.
description nvarchar(255) Explanation of the error with placeholders for parameters.
mslangid smallint System message group ID.


(c) 1988-98 Microsoft Corporation. All Rights Reserved.