Database Engine events and errors
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'
END,
[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;
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:
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:
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:
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:
Visit the following sections for more detail about error and event codes:
- Errors 0 to 999
- Errors 1,000 to 1,999
- Errors 2,000 to 2,999
- Errors 3,000 to 3,999
- Errors 4,000 to 4,999
- Errors 5,000 to 5,999
- Errors 6,000 to 6,999
- Errors 7,000 to 7,999
- Errors 8,000 to 8,999
- Errors 9,000 to 9,999
- Errors 10,000 to 10,999
- Errors 11,000 to 12,999
- Errors 13,000 to 13,999
- Errors 14,000 to 14,999
- Errors 15,000 to 15,999
- Errors 16,000 to 17,999
- Errors 18,000 to 18,999
- Errors 19,000 to 20,999
- Errors 21,000 to 21,999
- Errors 22,000 to 22,999
- Errors 23,000 to 25,999
- Errors 26,000 to 27,999
- Errors 28,000 to 30,999
- Errors 31,000 to 41,399
- Errors 41,400 to 49,999