System Error Messages

Troubleshooting SQL Server

Troubleshooting

System Error Messages

Topics in this section contain the text of Microsoft® SQL Server™ 2000 system error messages, arranged in order by error number. The tables in the topics include the error message number, the severity level, and the description, which is the text of the error message from the master.sysmessages table.

Additional topics are available for some of the system error messages, with an explanation of the issue and suggested actions for resolving the error.

The master.sysmessages table contains one row for each system error or warning that can be returned by SQL Server. The following table shows the column names in the sysmessages table.

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) Text of the error message with placeholders for parameters and variables to be inserted each time the error message appears in a specific context.
mslangid smallint System message group ID.

These symbols may appear in the error message text along with the system error message descriptions. The symbols are placeholders that will be replaced by specific values when the error text is generated in a particular context.

Symbol Meaning
%d, %ld, or %D Decimal integer
%x Hexadecimal number
%ls or %.*ls Character string
%S_type SQL Server -defined structure
%c Single character
%lf Double floating-point number