Table usage history

Question

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

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

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

What do you mean by used? There is no information created automatically about when the data in a table was read and/or modified.

MenTaT :-) SSC Eights! Points: 811 More actions · Answer 2

By used I mean the last time data was read or written.

If there is nothing other than in a log then I guess I can not determine that type of information, unless I put triggers on all tables I guess.

THanks anyways.

--Ron

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 3

But you cannot trigger for reads. You will need to trace with Profiler or similar for this information.