Post reply

Auditing the logons, what table(s) are they in?

  • February 2, 2012 at 3:40 am

    #250832

    Hello,

    I am auditing both successful and failed logins on my SQL server instances, but I'd like to know if they are kept in any SQL server system tables for me to query? If yes, does anybody know that table names so I can take a look?

    Thank you,

    D.

  • February 2, 2012 at 3:49 am

    #1441648

    I am not sure about the tables but if you want to get the details from t-sql. you can run

    sp_readerrorlog 0,1,'login'

    This reads from the error log and returns the details for the keyword Login.

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • February 2, 2012 at 4:04 am

    #1441650

    Perfect, thank you very much.

    Regards,

    D.

Viewing 3 posts - 1 through 3 (of 3 total)

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