Friday, March 9, 2012

List of SQL Server Error Messages

Hi All,
I was wondering if anybody knows where to get a complete list of SQL Server error messages. I am writing a stored procedure that scans SQL Server Logs for errors and if there are errors in the logs, I get paged.
Thanks.Personally, I just look for keywords. Like "error".|||books online has a lot extremely unhelpful descriptions unser Troubleshooting --> Error Messages --> Error Message Descriptions --> System Error Messages.|||there is a table sysmessages in master db|||That's great. But besides the error messages I am also looking for messages in the SQL Server logs such as SQL Server terminating, backup failed, scheduler appears to be hung etc. I found these messages in the SQL Server logs and would like to get a list of all the possible messages that can be found in the logs.

No comments:

Post a Comment