Lowell (6/23/2011)

---

instead of a trigger, i strongly recommend a scheduled job that migrates the data to the linked server.

if the linked server cannot be connected to(due to username/password, networking issues,...

Jayanth_Kurup (6/23/2011)

---

I am thinking the trigger should look something like

CREATE TRIGGER employee_insupd

ON employee

FOR INSERT

as

BEGIN

BEGIN TRY

Insert into server2.database.schema.table

select * from inserted

END TRY

BEGIN CATCH

Insert into server1.database.schema.table

select *...