Log File Viewer

Log File Viewer in SQL Server Management Studio is used to access information about errors and events that are captured in the following logs:

  • Audit Collection

  • Data Collection

  • Database Mail

  • Job History

  • Maintenance Plans

  • Remote Maintenance Plans

  • SQL Server¬†

  • SQL Server Agent

  • Windows NT (These are Windows events that can also be accessed from Event Viewer.)

Opening Log File Viewer

You can open Log File Viewer from several locations in Management Studio, depending on the information that you need. For more information, see How to: Open Log File Viewer.


Requires membership in the securityadmin fixed server role.