To view the Microsoft® Windows NT® application log, use the Windows NT Event Viewer. If you are part of the Windows NT Administrators group, you can also view remote application logs. The application log contains Microsoft SQL Server™ error messages as well as messages for all activities on the computer.
When you use the Windows NT application log, each SQL Server session writes new events to an existing application log; you can filter the log for specific events. Unlike the SQL Server error log, a new application log is not created each time you start SQL Server; however, you can specify how long logged events will be retained.