How to: View the SQL Server Error Log (SQL Server Management Studio)

The SQL Server error log contains user-defined events and certain system events. You can use this error log to troubleshoot problems related to SQL Server.

To view the SQL Server error log

1. In Object Explorer, expand a server, expand Management, and then expand SQL Server Logs.

2. Right-click a log and click View SQL Server Log.

See Also

Concepts

Monitoring the Error Logs

Help and Information

Getting SQL Server 2005 Assistance