Thanks for all your suggestions guys , i solved this yesterday using update triggers , i created an audit table and wrote a trigger in the table i wanted to...

thanks ramesh, problem is i can not modify the tables, i was hoping i could do this via code , where i can use the existing table structure ......

but with...