Home | Pinoy Relihiyoso | Sitemap

Monday, December 28, 2015

How To Get The Last Update Of Any Table In MSSQL?


How To Get The Last Update Of Any Table In MSSQL?

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'AdventureWorks')
AND OBJECT_ID=OBJECT_ID('test')

No comments :

Post a Comment