Post reply

SQL Server Error logs

  • July 13, 2008 at 5:55 am

    #188076

    Hi, does any one has a query/script to get the login failures on a server, rather than checking the sql server error logs?

    I was wondering if there is a script, as when I tried to open the sql server error log through management studio, I couldnt do as the size of the log file had increased drastically!!

    thanks

  • July 13, 2008 at 12:17 pm

    #842122

    I am told there is a third party prouct called textpad which can 'tail' the erorlog and Microsoft has a log file reader that's currently free. It's on their web site. Allows you to query the files as if they were SQL tables.

    Other than that try reading the errorlog file itslf from the log directory using notepad.

    Also cycle the log frequently using command sp_cycle_errorlog

    ---------------------------------------------------------------------

  • July 13, 2008 at 1:59 pm

    #842132

    Read this for an explanation of the undocumented sp_readerrorlog

    http://vyaskn.tripod.com/sp_readerrorlog_undocumented.htm

    Tried it in SSMS on SQL 2005 and it appeared to work, at least it did not report any errors.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • July 13, 2008 at 10:43 pm

    #842183

    Thanks sp_readerrorlog..worked!

  • July 20, 2008 at 11:57 pm

    #845527

    rinu philip (7/13/2008)

    Thanks sp_readerrorlog..worked!

    sp_readerrorlog works fine, while we have to read all the errors in the log file, but is there a way to check only the login failures??

    🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply