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