Database activity

  • 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.



  • 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)

  • 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

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

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