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.
LVL 16
Easwaran ParamasivamAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Harish VargheseProject LeaderCommented:
Hello,

If you do not have an earlier backup of the database where the value was 1 and if you are not maintaining an audit table for the changes, then the only solution may be to read from the transaction log (if you have NOT TRUNCATED the log after the update). If the log was cleared after the update was made, I doubt there may not be any way out.

Here is a blog that details how to read from transaction log.
http://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/

-Harish
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lcohanDatabase AnalystCommented:
My suggestion is to create a "audit" table if this is needed for any changed record and put a trigger on the parent OLTP table to populate the "Audit" table with all relevant info - who/when modified it, and what action - insert/update or delete?
0
Easwaran ParamasivamAuthor Commented:
The audit could implement now. But the question with the existing modified table which did not implement it. Is there no other way to track it?
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Harish VargheseProject LeaderCommented:
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
0
Monica PSoftware DeveloperCommented:
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...
0
Pankaj_401Commented:
Not sure about how you will find earlier changes made in SQL server.
But if you have Change Data Capture enabled, you could have better chance to track all the changes made in SQL.
Also, check this MS-Library.
A good resource you can also explore here for further assistance.
0
Anthony PerkinsCommented:
Is there no other way to track it?
No.
0
Easwaran ParamasivamAuthor Commented:
Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.