tags:

views:

7

answers:

0
+1  Q: 

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

I need to find if a certain table has had any activity(update/query). Is there are way to find this information in SQL Server 2000 (sp4 to be specific)

There is a helpful query using sys.dm_db_index_usage_stats, but it is supported only post SQL Server 2005. I am looking for something similar on SQL Server 2000.

Thank You for your time.

related questions

Table Column Formatting
How do you truncate all tables in a database using TSQL?
how to see the schema of a db2 table (file)
Tools for refactoring table-based HTML layouts to CSS?
Page working in FF, not in IE, where to start
Hiding table rows without resizing overall width...
DIV with overflow:auto and a 100% wide table problem
For tabular data, what renders faster, CSS or <TABLE>?
I need my html table's body to scroll and its head to stay put
How to line up items of varied length in a resizable space in CSS?
CSS to make a table column take up as much room as possible, and other cols as little
Best approach for sortable table with a lot of data
A more advanced table/spreadsheet SWT implementation
JSF how do I retrieve the selected rows of a woodstock table
How to scroll only the right side of a table, listview, or datagrid?
Make a div fill the remaining screen space
How to stretch an HTML table to 100% of the browser window height?
SqlServer create table with MySql like auto_increment primary key
Why not use tables for layout in HTML?
Should Tables be avoided in HTML at any cost?
HTML drag and drop sortable tables
CSS overflow table row positioning
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Configurable Table Prefixes with a .Net OR/M?
SQL Table Aliases - Good or Bad?