SQL Server – List of all the Error codes or messages
Contains one row for each system error or warning that can be returned by Microsoft SQL Server. SQL Server displays the error description on the user’s screen.
You can get the List of all the Error codes or messages as
USE master GO SELECT * FROM sysmessages
You will get the five columns as
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