How to check a Table whether data is changed or not..??

[bobkand]

Hi..

I got 10 Tables with data in it for 100 Loans. The data can be Good and Bad .....

I had a Update Proc which Updates the 10 tables with the Good data what ever i pass...for this 100 Loans
Tha Proc will update the existing data in all tables whether it is Good or Bad Data.

when the updating is completed I want to know what are the Loans that were updated where there is a Bad Data in atleast one Field of the 10tables.

I don't want to check field by field in each table.... if there is a bad data and my proc updated with a Good Data i want to know that Loan.

Can any one has an idea on this,,,,

Thanks
Bob

[MAK]

1. you could create an update trigger and a log table to capture the updates or

2. run profiler to find all the changes made to the table when running your proc.

[bobkand]

Hi Mak

Thanks for your quick reply.....is there any way i can use Binary_CheckSum and work on this.....