This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

This section contains error message numbers and their descriptions, which are taken from the text of the error message in the sys.messages catalog view. Where applicable, the error number is a link to further information.

You can query the Database Engine to see a full list of all errors, by running the following query against the sys.messages catalog view:

SELECT message_id AS Error,
    severity AS Severity,
    [Event Logged] = CASE is_event_logged
        WHEN 0 THEN 'No' ELSE 'Yes'
    [text] AS [Description]
FROM sys.messages
WHERE language_id = 1040 /* replace 1040 with the desired language ID, such as 1033 for US English */
ORDER BY message_id;
SQL Server version
This article shows events and errors for SQL Server 2016 (13.x). If you want to view events and errors for other versions of SQL Server, see:
SQL Server 2022
SQL Server 2019
SQL Server 2017
This article shows events and errors for SQL Server 2017 (14.x). If you want to view events and errors for other versions of SQL Server, see:
SQL Server 2022
SQL Server 2019
SQL Server 2016
This article shows events and errors for SQL Server 2019 (15.x). If you want to view events and errors for other versions of SQL Server, see:
SQL Server 2022
SQL Server 2017
SQL Server 2016
This article shows events and errors for SQL Server 2022 (16.x). If you want to view events and errors for other versions of SQL Server, see:
SQL Server 2019
SQL Server 2017
SQL Server 2016
Errors and events
Visit the following sections for more detail about error and event codes:
Errors 0 to 999
Errors 1000 to 1999
Errors 2000 to 2999
Errors 3000 to 3999
Errors 4000 to 4999
Errors 5000 to 5999
Errors 6000 to 6999
Errors 7000 to 7999
Errors 8000 to 8999
Errors 9000 to 9999
Errors 10000 to 10999
Errors 11000 to 12999
Errors 13000 to 13999
Errors 14000 to 14999
Errors 15000 to 15999
Errors 16000 to 17999
Errors 18000 to 18999
Errors 19000 to 20999
Errors 21000 to 21999
Errors 22000 to 22999
Errors 23000 to 25999
Errors 26000 to 27999
Errors 28000 to 30999
Errors 31000 to 41399
Errors 41400 to 42999
See also
Understanding Database Engine Errors
Cause and Resolution of Database Engine Errors