Calling Linked Server From Trigger

I've created instead of trigger in server A, in which I call a procedure, which in turn calls other procedure in linked server (server B). Trigger(A) -> Procedure (A) -> Proc

Solution 1:

You need to use DTC if you use linked servers within a trigger (not recommended as it's not performing well and your transaction will be aborted if there are any connection issues)

or

your Procedure (A) may populate some queue table, and then some scheduled task may read that queue table and run Procedure B.

or

use Replication or CDC (change data capture) + scheduled task to trigger Procedure B on remote server

or

use Local Service Broker