How to tell last update/insert activity on a table sql 2005

Question

Hello,

I am trying to find out when the last insert/update was done to a specific table in our sql 2005 db. The data does not have a timestamp, so I can not tell that way. Are there any dmv out there that would assist me in this?

Thanks, hp

Duplicate: http://stackoverflow.com/questions/301060/how-to-find-recent-sql-update-operations-acting-upon-a-certain-table-sql-server

Answer 1

Check this post.

Answer 2

I found a link that could help you out:

Last Update Time from blog.sqlauthority.com

A part of that post contains this code: where 'AdventureWorks' is the Catalog name and 'test' is the table name

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'AdventureWorks')
AND OBJECT_ID=OBJECT_ID('test')