thank you for the advice,

I am already trying to create a dynamic trigger.

in the mean while i am trying to get to know fn_dblog() better.

But i noticed a problem in the fuction.

while reading topics related to fn_dblog i noticed that there is a slot ID in fn_dblog that saves the slot ID of the updated record here is my scenario :

A record is updated then another record is deleted that is above the updated record then the slot ID of the updated table has changed but the Slot ID in the fn_dblog stays the same and when i run the procedure it indicates another row that has not been updated

EXAMPLE:

in the students tabel I have four records, record 1 with slot ID = 0, record 2 with slot ID = 1, record 3 with slot ID = 2 and recod 4 with slot ID = 3

I update Record 3 and the saved slot ID in fn_dblog is 2.

I delete Record 2 and the slot ID of Record 3 is now 1 but it stays 2 in fn_dblog.

i run Recover_Modified_Data_Proc it gives me Record 4 (things get more complicated with multiple deletes and updates)

is there any way to rectify this problem ?