Site Sections
Posts
33
Comments
186
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!
Gravatar
# re: Find out last modification to the SQL table
Dave
6/27/2016 9:29 AM
Goo query. However, after a SQL Server restart, they get reset, so you have to keep your server sunning 24/7 for this to work as expected.
Gravatar
# www.trickscentral.org
tutorials
5/22/2017 9:31 AM

TricksCentral is place where we will share latest Android Tricks, Windows Tips, iOS apps, Android Apk Downloads and more.
tricks central
Gravatar
# re: Find out last modification to the SQL table
Sawn Watson
6/23/2017 11:54 AM
Amazing Sharing. iModsApk is one of the best website which share daily tips and tricks on technologies. Visit https://imodsapk.com/ and subscribe it for daily updates.
Gravatar
# re: Find out last modification to the SQL table
Sawn Watson
6/23/2017 11:55 AM
Amazing Sharing. iModsApk is one of the best website which share daily tips and tricks on technologies. Visit https://imodsapk.com/ and subscribe it for daily updates.

Post Comment

Title *
Name *
Email
Comment *  
Verification
Archives