Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Thomas LaRock Customizable Error Log Scanning RE: Customizable Error Log Scanning

  • December 29, 2006 at 2:17 pm

    #680602

    I also changed this line to convert char to datetime -- before that I was getting lots of very old log entries emailed to me. 

    -- next, find the current max date in the ErrorsP1 table

    Select

    @MxDateDel = max(convert(datetime,Error_date)) from ErrorsP1

    Also removed "login failed for user" from ErrorlogScanExclude table because I don't get many and wanted to see them.

    INSERT INTO dbo.ErrorlogScanExclude ( Excludekeyword )

       VALUES ( 'Login failed for user' )

    go