SQL Server Management Studio Standard Reports – Number of Errors

I'm continuing my series on the Standard Reports in SQL Server Management Studio and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that appears, click the Standard Reports, and then select the title at the top of this post. This report shows information about the errors your system has reported. It’s a great report to review each morning when you do your system checks.

The first section of the report is a graph showing the Error count by type of error. It’s a good view to visually group the errors, so you can quickly see which errors are occurring most often.

The second section of this report shows the errors and information about them:

Column	Description
Error	The error returned by the SQL Server engine
Severity	INFORMATIONAL, WARNING, or ERROR. severity is optional, with a default of INFORMATIONAL.
Count	The number of times this error has occured
First Occurrence	The date and time the error first occurred
Last Occurrence	The date and time the error last occurred
Last Error Message	The text of the last error returned by the engine