Thursday, October 7, 2021

Table Data last updated SQL server

 SELECT OBJECT_NAME(OBJECT_ID) AS ObjectName,

 last_user_update,*

FROM sys.dm_db_index_usage_stats

WHERE database_id = DB_ID( 'mfdb')

AND OBJECT_ID=OBJECT_ID('tbl_verGLData_DD')