Script to Search SQL Error Log For a String

sp_dba_sqlerrorlog kernel



Edward J Pochinski III 
                

create proc sp_dba_sqlerrorlog @lookfor varchar(25)= ''

  AS
/******************************

sql-scripting 04/04/2001 

Visit www.sql-scripting.com 
Edward J Pochinski III 

******************************/ 

 

Declare @cmd varchar(55) 

     if @lookfor = '' 

Begin  

    Print '#################################################' 

    Print char(13)+'Must pass a string to search for.' 

    Print char(13)+'example: exec sp_dba_sqlerrorlog3 kernel ' 

    Print char(13)+'sql-scripting 6/17/01 www.sql-scripting.com ' 

    Print char(13)+'#################################################' 

  Return 

End 

    set @cmd = 'FINDSTR /I /C:"'+@lookfor+'" C:\MSSQL7\Log\errorlog' 

exec xp_cmdshell @cmd