Redirect Sql Server's Events From Std Application Log Into A Custom One

Had to seep through loads of info trying to restore the sequence of events that led to a crash yesterday, and got really interested in finding a solution to offload events from SQL

Solution 1:

ERRORLOG?

Solution 2:

If you wish to create an event viewer filter to exclude a particular source, here is the XML (Suppressing SQL Express events from the 'Application' log).

<QueryList><QueryId="0"Path="Application"><SelectPath="Application">*
    </Select><SuppressPath="Application">*[System[Provider[@Name='MSSQL$SQLEXPRESS']]]</Suppress></Query></QueryList>

See Event Selection on MSDN