I have searched high and wide trying to find a means to find a way to easily
determine the last time any record in a table was updated. We have a
database that (unfortunately) has tables defined that may no longer be used
... but there doesn't appear to be any means of determining the last time a
table was either accessed, or better yet updated. If we could determine
these it would allow us to delete those tables that are no longer
accessed/used. Any ideas are greatly appreciated. I have run this by
several DBAs with no answer.

The ideal scenario would have another column shown in Enterprise Manager
showing last access date and another column showing last update date.

Mike

MS Sql Server LazyDBA home page