• thanks Nj-dba!

    It worked. I'm getting the results.

    EW1\INS1Aug 16 2013 2:28PMError: 60000, Severity: 16, State: 1.

    EW1\INS1Aug 16 2013 2:28PMError while executing Usp_ErrorLogCheck procedure...

    Can you please tell me how to send the error in an email?

    and you used this script once upon a time. What methods you are using now to monitor sql server error log?