• Great article.  Writing a follow up - about how to "stage" the data and then scheduling external processing- would be awesome.  I've implemented it here but would love to here about someone elses methods.

    Another thing not to do in triggers...Don't use Linked Server!  I would consider linked SQL servers to be external, as they require a connection that can fail for reasons outside of SQLs control.  Instead, I use a staging table that get's moved to the linked server as a batch.  I've tested this and performance is bad enough when the network is fast; I'd hate to see it when the network is bogged down.

    An UNPROVEN problem I'm also having with triggers is when writing from one database to another on the same server.  For some reason I'm seeing a noticable performance degradation when I update a table in a different database.  I'm not sure this is not environment related, but I'm checking it out.

    cl

    Signature is NULL