Easwaran Paramasivam
asked on
How to identify particular table value is modified when?
Hi Experts,
I've table called tBalance. For Player id 1040 the value IsVoid was 1 intially. Someone has updated this values as 0. How to ensure the customer that it was preiously one and now it is zero?
Kindly advice.
I've table called tBalance. For Player id 1040 the value IsVoid was 1 intially. Someone has updated this values as 0. How to ensure the customer that it was preiously one and now it is zero?
Kindly advice.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did you try reading from the transaction log? If the update had happened prior to last database backup, you may have to read from the transaction log of from the backup.
-Harish
-Harish
To track the updates what i have used is ..
This in case if update is made from website :
I have written the function in .net code to track the logged user and his action (insert,update,delete) into another table...Using that table i can view the Action performed by that user.
to Track all updates in that table .,
you can also use trigger to write a log in another table., to track the person & operation he done.
I not know this solution is best...just shared my view...
This in case if update is made from website :
I have written the function in .net code to track the logged user and his action (insert,update,delete) into another table...Using that table i can view the Action performed by that user.
to Track all updates in that table .,
you can also use trigger to write a log in another table., to track the person & operation he done.
I not know this solution is best...just shared my view...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is there no other way to track it?
No.
No.
ASKER
Thanks.
ASKER