Errors in SQL Server

09Jun09

If you had worked with Sql certainly you saw the error message below.

Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint ‘PK_MYTABLE’. Cannot insert duplicate key in object ‘MYTABLE’.
The statement has been terminated.

The message has five components:

Msg
Each error message has a number starting with 0.
Message numbers from 50001 and up are reserved for user-defined use. Lower numbers are system defined.

Level

This defines the severity of the error generated.
It is a number between 0 and 25

0-10 defines some informational message or a warning
11-16 are the errors in the programming
17 and above defines problems with the lack of server resources or hardware problems

Above 20 will terminate the connection

State
This is a number between 0 and 127.
There is not much information disclosed about this by Microsoft… so I will not discuss this in this post.

Line
This specifies the line number in the procedure/function/trigger/batch where the error has actually occurred.

Msg Desc
Check it out the table sysmessages

select * from master..sysmessages

That’s all folks…

Filed under: Sql   |  Leave a Comment
Tags: error, example, level, line, msg, mssql, Server, Sql, state, sysmessages, T-Sql