Sometimes We Tend to search for Error Codes and Error messages. We require this for trouble shooting.
SELECT message_id as Error_Code, severity, is_event_logged as Logged_Event, text as [Error_Message] FROM sys.messages WHERE language_id = 1033;
Tags: #SQL Server, TSQL, #TSQL, SQL Server, BRH,