Home Forums SQL Server 7,2000 Administration How to Export error log (filter on specific errors) as a job RE: How to Export error log (filter on specific errors) as a job

  • April 29, 2005 at 12:18 am

    #555772

    Try on code similar like this

    CREATE TABLE #errors

    (errorlog varchar(255), continuationrow int)

    INSERT #errors

    (errorlog, continuationrow)

    EXEC xp_readerrorlog

    SELECT errorlog

    FROM #errors WHERE errorlog LIKE '%Login failed%'

    DROP TABLE #errors

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]