SQL-Server-Logo

List of all the Error codes or messages in SQL Server

In SQL Server you can get list of all the error codes or messages using below queries

Sometimes it is very difficult to understand the error from the code only. So if you are also facing same issue while working on SQL Server, below are the queries made for you. By hitting below queries you will get all the error codes and its detail SQL Server can throw to you.

In tables written after SQL query we have tried to explain you the return result of the query.

In SQL Server 2000

USE MASTER
GO
SELECT * FROM SYS.MESSAGES
Column name Description
error Unique error number.
severity Severity level of the error.
dlevel For internal use only.
description Explanation of the error with placeholders for parameters.
mslangid System message group ID.

In SQL Server 2005 & above

USE MASTER
GO
SELECT * FROM SYS.MESSAGES
Column name Description
message_id ID of the message. Is unique across server. Message IDs less than 50000 are system messages.
language_id Language ID for which the text in text is used, as defined in syslanguages. This is unique for a specified message_id.
severity Severity level of the message, between 1 and 25. This is the same for all message languages within a message_id.
is_event_logged 1 = Message is event-logged when an error is raised. This is the same for all message languages within a message_id.
text Text of the message used when the corresponding language_id is active.

Leave a Reply