Get List of affected rows from table in SQL Server

Hi sadat,

Refer the below query to get the last affected table by database name.

SELECT TOP (1) OBJECT_NAME(OBJECT_ID) AS DatabaseName, db.last_user_update LastChanges
FROM sys.dm_db_index_usage_stats db
WHERE database_id = DB_ID( 'Test') --Test is the DataBase Name
ORDER BY db.last_user_update DESC

From the table name now you are able to get the last affected row by different way like if you save the lastmodified column or you can use trigger also. But you are not able to get the deleted records for that you have use third party tool like ApexSQL used to read transaction logs and recover deleted data.