Hi Ahamed Azeem, Please follow the below db statement. SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,* FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID( 'Your DB Name') AND OBJECT_ID=OBJECT_ID('Your Table Name'). It'll show you last modified DateTime for a particular table in a particular DB. U can remove where condition to view all the records from all the DB tables. I think u understand it:thumbsup:..
Rajendra Prasad panchati .Net/Sharepoint Software Engineer. Hyderabad.