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:
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.
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 😀
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.
This specifies the line number in the procedure/function/trigger/batch where the error has actually occurred.
Check it out the table sysmessages
select * from master..sysmessages
That’s all folks… 😀