Site Sections
Posts
23
Comments
30
Trackbacks
0
<< SQL Server Management Studio crashed - recover unsaved sql query | Home | SQL server - get list of active connections to each database >>
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
Url
Comment *  
 
Archives
Post Categories