SQL SERVER error messages - sys.messages

SELECT * FROM sys.messages

sys.messages return the list of the error messages in the system

http://msdn.microsoft.com/en-us/library/ms187382.aspx

List of the severities of the errors:

http://msdn.microsoft.com/en-us/library/ms164086.aspx