View SQL Server Error Logs in Query
EXEC xp_readerrorlog -- (current error log file)
EXEC xp_readerrorlog 3 -- (error log file number #3)
You can re-cycle the error log by executing the DBCC ERRORLOG command (or) the sp_cycle_errorlog system procedure.
