Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Angry Unanswered: SQLServer2000-User Last Login info

    I want to be able to see the last login for every user, even if it was
    before today in any user database combinedly listing all. Tried to query master..sysprocesses but the last_login or last_batch shows just for today. Can someone help with code or table query how to get this information. Auditors want to see when any user has last logged into any database. Any help is appreciated

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Code:
    SELECT accdate, name
       FROM master.dbo.syslogins
    -PatP

  3. #3
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134
    Thanks a lot

Posting Permissions

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