No... You want to do this as a Trigger to fire your update from your source db to your destination. You will want to do it at the time of the transaction as your don't want to clean up a bunch of garbage.

Kent
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's