android activity - How to find when a table was last accessed/updated for SQL Server 2000 sp4 -


I have to find out if there is any activity (update / query) in a given table. There is a way to find this information in SQL Server 2000 (SP4) to be specific.

Using a sys.dm_db_index_usage_stats is a useful query, but it is only supported after SQL Server 2005. I'm looking for something similar on SQL Server 2000


Comments