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
/* replace language_id code with the desired sys.syslanguages.msglangid.
1033 is for US English */
WHERE language_id = 1033 
ORDER BY message_id;

SQL Database Engine version

Many error codes are shared across different platforms using the SQL Database Engine.

Errors and events

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

Related content

• Understanding Database Engine errors
• Cause and resolution of Database Engine errors