The error log is a central file where all important actions and error messages related to the SQL Server are recorded. The database administrator should examine the log every day. The following procedure describes how to view the error log with the Microsoft SQL Server Management Studio.
1. In the Microsoft SQL Server Management Studio, expand the SQL server.
2. In the Object Explorer, select Management ® SQL Server Logs.
3. Choose the error log you want to see, for example the current log file.
The date beside the log indicates when a log was changed the last time.
4. Double-click the log file or right-clickon it and select View SQL Server Log.
In the left-hand window, you see a list of all error logs.
In the right-hand window, you see the content of the selected files.