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:
|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|