SQL Error log can be read from SQL Server's management studio. However, Management studio is too slow and definitely not the greatest way of taking a quick look at SQL Error log. Sp_readerrorlog is definitely a much better command which can help us read a error log must faster way. Also , the script below Dumps the read error log into a temporary table. Once dumped one can use different kinds of filters as per our needs.
The script below loads error log into a temporary table, filters for a particular date range, removes error log entries for backup, and searches only for genuine error on the error log.
CREATE TABLE #error_log_dt
INSERT INTO #error_log_dt
WHERE logdate BETWEEN '20110815' AND '20110821'
AND processinfo != 'backup'
AND text_data LIKE '%error%'
DROP TABLE #error_log_dt