Last post Dec 24, 2014 12:18 AM by Edwin Guru Singh
Dec 23, 2014 04:14 AM|muhammadnabilch|LINK
I want to know the Last Modifications in Table DATA ....Want to see Date and Time with SQL QUERY. THANKS
Dec 23, 2014 04:39 AM|akhilrajau|LINK
Use the below query which shows all tables last modified time
SELECT name, [modify_date] FROM sys.tables
Dec 24, 2014 12:18 AM|Edwin Guru Singh|LINK
As per your case, you can try the following query :
SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,* FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'YourDatabaseName')
For more details,check the following link :
This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore,
Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you
completely understand the risk before retrieving any software from the Internet.
Hopefully this will be helpful for you.