To view the Windows NT application log
Microsoft® SQL Server™ events are identified by the entry MSSQLServer in the Source column. SQL Server Agent events are identified by the entry SQLServerAgent. Microsoft Search service events are identified by the entry Microsoft Search.
Complete the Select Computer dialog box.
Note If you are viewing the log of the local computer, skip this step.
To view only SQL Server Agent events, select SQLServerAgent instead.
How to view the SQL Server error log | Viewing the Windows NT Application Log |