1 out of 1 rated this helpful - Rate this topic

Log File Viewer

SQL Server 2008 R2

SQL Server 2008
SQL Server 2012

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.

Concepts

Data Collector Logging

Understanding SQL Server Audit

Using the SQL Server Agent Error Log

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD