Show Error Logs

–ShowErrorLogs.sql
set nocount on

exec xp_ReadErrorLog 0, 1, ‘error’ — current sql error log
exec xp_ReadErrorLog 0, 1, ‘fail’
exec xp_ReadErrorLog 0, 2, ‘error’ — current sql agent log
exec xp_ReadErrorLog 0, 2, ‘fail’

from source article
http://www.sqlteam.com/article/using-xp_readerrorlog-in-sql-server-2005