Last Modified Date

I have a number of tables in a database that have 0 records. Some tables are
purged frequently. I am trying to determine which tables are truly in use
versus those tables that are not being used at all. Where or how might I
obtain the last date/time a table was modifed?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200510/1Robert,
You would need to have had Profiler or some third-party auditing tool
running to determine this. Another option would be to use some extra
auditing code in the tables or use triggers. C2 is probably overkill for
something like this.
Read these:
http://www.microsoft.com/technet/se...r/sql2kaud.mspx
and
http://www.akadia.com/services/sqls...e_auditing.html
HTH
Jerry
"Robert R via droptable.com" <u3288@.uwe> wrote in message
news:55d4d8776aa3c@.uwe...
>I have a number of tables in a database that have 0 records. Some tables
>are
> purged frequently. I am trying to determine which tables are truly in use
> versus those tables that are not being used at all. Where or how might I
> obtain the last date/time a table was modifed?
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200510/1