Skip to content

database-engine-events-and-errors.md

Latest commit

 

History

History
111 lines (92 loc) · 6.28 KB

database-engine-events-and-errors.md

File metadata and controls

111 lines (92 loc) · 6.28 KB
title Database Engine events and errors
description Consult this MSSQL error code list to find explanations for error messages for SQL Server database engine events.
author rwestMSFT
ms.author randolphwest
ms.reviewer maghan, mikeray
ms.date 11/18/2025
ms.service sql
ms.subservice supportability
ms.topic error-reference
monikerRange =azuresql || =azuresql-db || =azuresql-mi || >=aps-pdw-2016-au7 || >=sql-server-2016 || >=sql-server-linux-2017 || =fabric-sqldb

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" 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:

::: moniker range=">=sql-server-ver17 || >=sql-server-linux-ver17 || =azuresql || =azuresql-db || =azuresql-mi || >=aps-pdw-2016-au7 || =fabric-sqldb" This article shows events and errors for [!INCLUDE sssql25-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