October 10, 2002 at 6:10 am
I am looking for the best way to track changes in data.
Example:
Table XYZ with 20 columns.
User can change data in some or all of the columns via app per record
What I need is a history tbl where I can see which user updated which data.The user
user and date history is no problem but getting the column data is a problem, because
it must be only the change data.
example : "10/10/2002 13:00:00","WORKGROUP\USERNAME","Column:Surname CHANGE TO 'Kraai';Column:Name Change to 'Pompei'";
Thanks
Spaski
October 10, 2002 at 6:15 am
Great i am in the wrong place with this quetstion, sorry.
I will post this in the right place
cheers
October 10, 2002 at 2:12 pm
You will need to write triggers on all of the tables you want to track.
Not pretty, but it can be done. I did it a few years ago on a database with a small number of tables.
Be great!
Michael
Be great!
Michael
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply