Script to see only errors in SQL error log

When we encouter some issue in SQL , first we check SQL errorlog. As lot of other information is also present in errorlog sometimes it takes time to reach to actual error.Here is small script which you can use to efficiently fetch errors from errorlog.

CREATE TABLE #errorlog_info
  (
     logdate     DATETIME,
     processinfo VARCHAR(30),
     text_data   VARCHAR(MAX)
  )
INSERT INTO #errorlog_info
EXEC Sp_readerrorlog
SELECT *
FROM   #errorlog_info
WHERE  processinfo != 'backup'
       AND text_data LIKE '%error%'
DROP TABLE #errorlog_info