FInd when was the table last updated..

Using the below tsq, you can find out when was a table last updated –

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID('Replace your DB Name here')
AND OBJECT_ID=OBJECT_ID('Replace your Table Name here')

Leave a Reply

Your email address will not be published. Required fields are marked *