Vipin Agarwal
Tips & tricks on .Net, SQL & Javascript
Site Sections
Home
Contact
Syndication
Login
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')
Share This Post:
Short Url:
http://wblo.gs/dc1
posted on Friday, March 1, 2013 3:30 PM
Print
Comments
#
re: Find out last modification to the SQL table
Ben Barreth
3/1/2013 5:09 PM
Nice tip - Thanks!
#
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.
#
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
#
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.
#
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
Remember Me?
Archives
January 2016 (2)
November 2015 (1)
August 2015 (1)
June 2015 (2)
July 2014 (1)
March 2014 (1)
July 2013 (1)
June 2013 (1)
March 2013 (5)
February 2013 (3)
March 2012 (5)
June 2011 (5)
October 2010 (1)
September 2010 (1)
March 2010 (3)
Post Categories
VS2013
Prism Windows 8.1 MVVM
SQL2012
MVC
ReSharper
Copyright © 2005 Vipin
This work is licensed under a
Creative Commons License