March 22, 2002 at 4:14 am
I have a table and need to perform a low cost query to find out the last time an insert occured.
I cannot query the table directly as it is very large. So am seeking the information either through the system tables or sql command.
Anyone?
March 22, 2002 at 4:48 am
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
thanks
March 22, 2002 at 5:55 am
If you only allow access to the table via stored proc you can add a logging line in it.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply