Thanks for the response, sorry it took me a while to respond.
So what you're saying is that there are system tables I can access from the triggers called inserted and deleted. I can take a record from these tables and dump it into another table.
Is there any built in functionality to do this automatically?
Jim
>Hey, Jim,
>
>Just like Bonnie and John said, table triggers will do the trick.
>
>In particular, in an update trigger, you have access to two system tables called INSERTED and DELETED. I believe they have the same structure as the table you're checking, with one row per record updated.
>
>So you can look at both to see what was changed ('inserted' has the new stuff, 'deleted' is basically what the row looked like before the update...so you can figure out 'old value', 'new value', etc.)
>
>Check the SQL books on line help file...I believe they have some info and maybe some sample code.
>
>Kevin
Thanks
Jim