User Log in history

  • Is there a way to see the history of a user's logged in.   I'd like to know the last time a user logged in.  How would I do that?

     

    Thanks for info,

     

    Steve

  • Steve

    You need to enable auditing.  You can audit successful logins, failed logins, or both.  Search for audit logins in Books Online.

    If you don't have auditing enabled yet and you need this information for something that has already happened, then I think you're out of luck.

    John

  • see database.ldf file

    Your database name.ldf file in "data" folder .

     

    Thanks

    Laxman27@gmail.com

     

  • "see database.ldf file"

    HUH ?!?!?!?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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