Skip to content

Latest commit

 

History

History
88 lines (68 loc) · 4.73 KB

database-engine-events-and-errors-0-to-999.md

File metadata and controls

88 lines (68 loc) · 4.73 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic monikerRange
Database Engine events and errors (0 to 999)
Consult this SQL Server error code list (between 0 and 999) to find explanations for error messages for SQL Server database engine events.
rwestMSFT
randolphwest
09/12/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 (0 to 999)

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

Errors and events (0 to 999)

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

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

::: moniker range="=sql-server-ver15 || =sql-server-linux-ver15" [!INCLUDE sql-server-2019-database-engine-events-and-errors-0-999] :::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-0-999] :::moniker-end

Related content