Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2002
    Posts
    8

    Wink Unanswered: retrieve user access log

    hi,

    im having a urgent issue here and hope someone here could give me a clue, im using ms sql 2008 and would like to know how to retrieve info of who has login to database before for the passed 3months. is there a system table or view in mssql that stored these information?

    hope to hear your advice soon.

    thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    If you set up SQL Server to log all logins and outs then it will be in the log.

  3. #3
    Join Date
    Oct 2002
    Posts
    8
    hi,

    what if i dont? means no others way to overcome this?

    thanks.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You can't audit this retrospectively without having set up appropriate tracking in the first place.

  5. #5
    Join Date
    Oct 2002
    Posts
    8
    ok, thanks and really appreciate ur promptly reply.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •