Skip to content

Latest commit

 

History

History
88 lines (68 loc) · 4.81 KB

database-engine-events-and-errors-2000-to-2999.md

File metadata and controls

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

Database Engine events and errors (2000 to 2999)

This article contains error message numbers (between the range 2,000 and 2,999) and their description, which is the text of the error message from the sys.messages catalog view. Where applicable, the error number is a link to further information.

For the full range of error numbers, see the list on Database Engine events and errors.

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 (between the range 2,000 and 2,999) 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 (between the range 2,000 and 2,999) 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 (between the range 2,000 and 2,999) 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 (between the range 2,000 and 2,999) for [!INCLUDE sssql22-md]. If you want to view events and errors for other versions of [!INCLUDE ssnoversion-md], see:

Errors and events (2000 to 2999)

::: moniker range="=sql-server-2016" [!INCLUDE sql-server-2016-database-engine-events-and-errors-2000-2999] :::moniker-end

::: moniker range="=sql-server-2017 || =sql-server-linux-2017" [!INCLUDE sql-server-2017-database-engine-events-and-errors-2000-2999] :::moniker-end

::: moniker range="=sql-server-ver15 || =sql-server-linux-ver15" [!INCLUDE sql-server-2019-database-engine-events-and-errors-2000-2999] :::moniker-end

::: moniker range=">=sql-server-ver16 || >=sql-server-linux-ver16 || =azuresql || =azuresql-db || =azuresql-mi || >=aps-pdw-2016-au7" [!INCLUDE sql-server-2022-database-engine-events-and-errors-2000-2999] :::moniker-end

Related content