How to find when data (row) of a table is last updated?


Please execute below query to find when data (row) of a table is last updated: 

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( '<Database Name>')
AND OBJECT_ID=OBJECT_ID('<Table Name>')


Comments