July 8, 2002 at 10:00 am
We have a Sql 6.5 DB and noone knows if it used for anything anymore. Is there a "most recently used" timestamp or some way I can check the last DB access date?
TIA,
Bill
July 8, 2002 at 10:03 am
No. Easiest way to do this is run Trace and check for activity in that db. Maybe for a month. If nothing appears, then you can archive it.
Steve Jones
July 9, 2002 at 6:23 am
Trace is your best option and your only true option with SELECT queries. If however there are UPDATE and INSERT and DELETE queries you can use triggers instead to generate a stamp of your own.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 2, 2007 at 12:22 pm
Are there not some system tables that are keeping track of the last access - if not by select, delete, insert, update, by row or even just table?
August 3, 2007 at 12:38 pm
Don't forget that the minute you go to update the database, you will corrupt any 'last-used' date stamp.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply