Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
The SQL Server error log contains user-defined events and certain system events you can use for troubleshooting.
In SQL Server Management Studio, select Object Explorer. To open Object Explorer, select F8
. Or on the top menu, select View, and then select Object Explorer:
In Object Explorer, connect to an instance of SQL Server, and then expand that instance.
Find and expand the Management section (assuming you have permissions to see it).
Right-click SQL Server Logs, select View, and then choose SQL Server Log.
The Log File Viewer appears (it might take a moment) with a list of logs for you to view.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Manage and monitor Windows Server event logs - Training
Learn how Event Viewer provides a convenient and accessible location for you to observe events that occur. Access event information quickly and conveniently. Learn how to interpret the data in the event log.
Documentation
Open Log File Viewer - SQL Server
Learn to use Log File Viewer in SQL Server Management Studio to access information about errors and events that are captured in several logs.
Viewing the SQL Server Error Log - SQL Server
Get help detecting problems in SQL Server by viewing the current error log, or backups of previous logs, to check whether processes finished successfully.
sp_readerrorlog (Transact-SQL) - SQL Server
sp_readerrorlog allows you to read the contents of the SQL Server or SQL Server Agent error log file and filter on keywords.