error log

SQL Server error log records status and error information from SQL Server. It can be viewed using SQL Enterprise Manager or any text editor. When SQL Server is configured to use its error log, each SQL Server session creates a new log, and SQL Server retains the last six logs created.