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:
Remote Maintenance Plans
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.