>I do not know what is standard practice so I can not answer that question, but one thing I would be careful with that scenario is what is your trigger going to do when the linked server (or the connection for that matter) is down for any reason.Yes, Hugo ... I was wondering about that myself. Another option has been suggested to me on another forum (MSDN) and that is to use Sql Server Service Broker (which uses asynchronous messaging) ... this actually sounds pretty good to me, so I'm researching that as well.
~~Bonnie