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. |
I have healthy knowledge and experience in Azure, O365 and ASP.Net with c#, MVC, WebApi along with client-side frameworks and libraries like JavaScript, JQuery, KnockoutJs, AngularJs, Angular, ReactJs, NodeJs
