how to display last modified record from sqlserver table?

Question

Vasanth · Answer

Last record update for all tables in the database  SELECT OBJECT_NAME ( OBJECT_ID ) AS DatabaseName  last_user_update * FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID ( DBName' ) AND OBJECT_ID = OBJECT_ID ( 'test' ) For table structure modification  select [name]create_datemodify_date from sys.tables WHERE create_date modify_date ORDER BY modify_Date Please mark as answer  if it helps you.