Skip to content

Latest commit

 

History

History
97 lines (80 loc) · 5.38 KB

database-engine-events-and-errors.md

File metadata and controls

97 lines (80 loc) · 5.38 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic monikerRange
Database Engine events and errors
Consult this MSSQL error code list to find explanations for error messages for SQL Server database engine events.
rwestMSFT
randolphwest
01/11/2024
sql
supportability
reference
=azuresql || =azuresql-db || =azuresql-mi || >=aps-pdw-2016-au7 || >=sql-server-2016 || >=sql-server-linux-2017

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 [!INCLUDE ssde-md] 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;

SQL Server version

::: moniker range="=sql-server-2016" This article shows events and errors for [!INCLUDE sssql16-md]. If you want to view events and errors for other versions of [!INCLUDE ssnoversion-md], see:

::: moniker range="=sql-server-2017||=sql-server-linux-2017" This article shows events and errors for [!INCLUDE sssql17-md]. If you want to view events and errors for other versions of [!INCLUDE ssnoversion-md], see:

::: moniker range="=sql-server-ver15||=sql-server-linux-ver15" This article shows events and errors for [!INCLUDE sssql19-md]. If you want to view events and errors for other versions of [!INCLUDE ssnoversion-md], see:

::: moniker range=">=sql-server-ver16 || >=sql-server-linux-ver16 || =azuresql || =azuresql-db || =azuresql-mi || >=aps-pdw-2016-au7" This article shows events and errors for [!INCLUDE sssql22-md]. If you want to view events and errors for other versions of [!INCLUDE ssnoversion-md], see:

Errors and events

Visit the following sections for more detail about error and event codes:

Related content