Posts
27
Comments
64
Trackbacks
0
Find out last modification to the SQL table
If you need to find when was the table last updated for insert/delete/update .. use the below query to find it. It will show you the last updated datetime for the table

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, 
last_user_update, *

FROM sys.dm_db_index_usage_stats

WHERE database_id = DB_ID( 'DB_Name')
AND OBJECT_ID=OBJECT_ID('table_Name')
posted on Friday, March 1, 2013 3:30 PM Print
Comments
Gravatar
# re: Find out last modification to the SQL table
Ben Barreth
3/1/2013 5:09 PM
Nice tip - Thanks!

Post Comment

Title *
Name *
Email
Comment *  
Verification