Error log in SQL 2005 management

Using xp_ReadErrorLog in SQL Server 2005

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

CREATE TABLE FarlowErrorLog
(
RowID int IDENTITY PRIMARY KEY,
EntryTime datetime,
source varchar(50),
LogEntry varchar(4000)
)

insert into FarlowErrorLog (entrytime, source, logentry)
execute master..xp_readerrorlog

Monitor the SQL Server Error Log

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=ErrorLogMon