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.
Permissions
Requires membership in the securityadmin fixed server role.