Thank this author by sharing:
By Allan Roodt,
This script inserts all the entries in the errorlogs to a Temporary table and does a SELECT on that table based on all the error messages found in SQL ( from sysmessages table) to show only information which are of concern or which may need action. This was my first attempt and any modifications and suggestions are welcome. Please take note that this script is HUGE! ( about 24400 lines long ).
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.