Get List Of All Error Codes In SQL Server

We can get all the error messages by running the below SQL command:-

USE master

GO

SELECT * FROM dbo.sysmessages

This will return Error numbers that uniquely identifies the error, Severity level which defines nature of the error, Dlevel is used for internal purpose,  Description defines explanation of the error that occurred and Mslangid is system message group ID.

Output: