Home » CodeProject » SQL Server – List of all the Error codes or messages

SQL Server – List of all the Error codes or messages


Question:

I want list of all error codes & messages of SQL server.

Answer:

Once some ask this thing to you or this though comes to your mind, I am sure most of us will start goggling or looking into BOL for the details

But SQL server also Contains one row for each system error or warning that can be returned by Microsoft SQL Server.

You can get the List of all the Error codes or messages as

In SQL Server 2000

USE MASTER

GO

SELECT * FROM SYSMESSAGES

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.
About these ads

5 Comments

  1. Sarah says:

    Hi I tried to execute that script however it post different languages.

  2. Sarah says:

    Apologies. I already found out the problem. Thank you for sharing the script anyway.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 231 other followers

%d bloggers like this: