Post reply

Login information from SQL Server 7.

  • July 2, 2004 at 6:21 am

    #164209

    Where can I find out the last time a Login logged in ? Not in syslogins our sp_helplogins !

    thanks

    M.

  • July 2, 2004 at 7:35 am

    #513152

    I'm thinking that you could audit these in SQL 7, not sure. But if you can, then it's in the SQL Server log. You'd have to have turned this on, it doesn't do it by default.

     

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • July 2, 2004 at 8:47 am

    #513183

    Is this information not stored in any system table ? I have inherited a server and I just want to check for logins that may have been unused for a certain length of time

  • July 2, 2004 at 9:48 am

    #513196

    Unfortunately, none of the system tables stores the login information. As steve mentioned, you need to turn the logging on.

  • June 18, 2006 at 12:54 am

    #644493

    Hi,I have the same requirement,I would like to know unused user accounts in my database,for that I need to know when a user last logged on to the database?

    I am using SQLSERVER 2000,is there any system table where can I get these information?

    Thanks

    Arun

  • June 18, 2006 at 12:54 am

    #644492

    Hi,I have the same requirement,I would like to know unused user accounts in my database,for that I need to know when a user last logged on to the database?

    I am using SQLSERVER 2000,is there any system table where can I get these information?

    Thanks

    Arun

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

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