sql server connect: Is it possible to write a trigger from an MS SQL 2005 table to a linked
DB2/400 table?

-Todd

Todd,

I have never done this myself, but if the linked server has no setup
problems a trigger should be able to access the tables on the other side of
the linked server. (However, in many cases there is considerable
performance overhead in doing joins and updates across a linked server.)

In order to test it out, try creating a work table on DB2/AS400 and insert
some data to that table from your trigger. If it gets through, then all is
well. If it does not, then your error messages may be instructive.

RLF

[quoted text, click to view]