Post reply

How do I check the last time a table was touched

  • March 22, 2002 at 4:48 am

    #425897

    Sorry there is no direct way to know when table was last touched unless you have a audit system built for inserts, updates, deletes, or even selects (but those get tricky). You could try an app like Log Explorer which can read the log file and as long as an insert has occurred since the last truncation of the log and I believe it will show you the time.

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

  • March 22, 2002 at 4:54 am

    #425899

    thanks

  • March 22, 2002 at 5:55 am

    #425912

    If you only allow access to the table via stored proc you can add a logging line in it.

    Andy

    Andy
    Connect with me on LinkedIn

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

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