About sp_readerrorlog ...
In this article(!!) let us understand the system stored procedure Sp_readerrorlog in detail. At the time of writing this article I have tested it in SQL Server 2K.
Sp_readerrorlog is a system stored procedure which can be used to read the SQL Server error logs from within T-SQL.
Syntax of sp_readerrorlog
Parameter 1 : Non zero integer value Parameter 2 : File name Parameter 3 : Line number in the file Parameter 4 : Search string1. Code snippet to display the content of the current event log
Execute sp_readerrorlog
2. Code snippet to display the content of eventlog.1
EXEC sp_readerrorlog 1, 'C:\Program Files\Microsoft SQL Server\MSSQL$Velias\log\ERRORLOG.1'
Or
EXEC sp_readerrorlog 1
3. Code snippet to search a string
--Would search the second row of the specified text file for the number 2000.
EXEC sp_readerrorlog 1, 'C:\SendToTextFile.txt',2, '2000'
Yep you got it right ... this system stored proc can be used not only on log file but on any file (as shown in the above code snippet).
To import the SQL Error Logs, format it and then allow querying using TSQL ... check out
http://www.replicationanswers.com/Downloads/ErrorLogs.txt