Post reply

who last logged into db

  • April 19, 2004 at 9:02 am

    #85180

    I am trying to find a script  or trigger to find out when a db was last used.  I thought there was one here, but searches mostly come up with links "user xyz last logged into forum on 3/3/1999 10:50". 

     

     

  • April 20, 2004 at 3:51 am

    #503446

    I don't think that there is something like That in SQL Server.

    I think you have to Make Audit Table in your Database and in every trigger in all tables, add Code to Add User to your audit table

    any other ideas.?


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

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

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