Post reply

Database activity

  • March 19, 2002 at 12:29 pm

    #75935

    Hi all,

    How can i find out about when was the last time a database was used.I mean the last activity on a database occured.

    Thanks,

    Meena

  • March 19, 2002 at 1:16 pm

    #425654

    Unless you have a column that updates when changes occurr or something else to hook, then the tranasaction log would be your only help and I don't know of and inexpense tool to see the transaction times and you would have to know the last time the file was truncated.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • March 19, 2002 at 4:10 pm

    #425664

    Antares is correct. There is no way to know when activity occurs. You would also have to define activity. Is this an Insert/Update/Delete or a Select? Harder to track selects.

    Steve Jones

    steve@dkranch.net

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

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