Posts
33
Comments
186
Trackbacks
0
Friday, March 1, 2013
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 | Comments (5)