Guys

I am also looking for the below solution.In addition is it possible to get
last database access date by a given login?

Thanks
B

-----Original Message-----
From: mdefnet
[mailto:mssqldba-ezmlmshield-x49937099.[Email address protected]
Sent: Wednesday, June 30, 2004 2:27 AM
To: LazyDBA Discussion
Subject: table update date


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


==============================================================================

If you are not an intended recipient of this e-mail, please notify
the sender, delete it and do not read, act upon, print, disclose,
copy, retain or redistribute it.

Click here for important additional terms relating to this e-mail.
<http://www.ml.com/email_terms/>

==============================================================================

MS Sql Server LazyDBA home page