Last table date access

I need to know the last time each table on my database was accessed or
modified. Is that possible? I'm usign SQL Server 2000.Not unless you have been running a trace for a while.
Andrew J. Kelly SQL MVP
"Huacuz" <Huacuz@.discussions.microsoft.com> wrote in message
news:C640BB82-4F63-4B41-9600-BAEED7396F57@.microsoft.com...
> I need to know the last time each table on my database was accessed or
> modified. Is that possible? I'm usign SQL Server 2000.|||Hi
If you want an off the shelf product you could look at AuditDB from Lumigent
http://www.lumigent.com/Products/auditdb_sql.html
John
"Huacuz" wrote:

> I need to know the last time each table on my database was accessed or
> modified. Is that possible? I'm usign SQL Server 2000.|||What is your definition of 'accessed'; perhaps any time any process selects
a row for any reason?
"Huacuz" <Huacuz@.discussions.microsoft.com> wrote in message
news:C640BB82-4F63-4B41-9600-BAEED7396F57@.microsoft.com...
> I need to know the last time each table on my database was accessed or
> modified. Is that possible? I'm usign SQL Server 2000.|||> I need to know the last time each table on my database was accessed or
> modified. Is that possible?
Not without using Profiler or 3rd party auditing tools, no.