Insert into table on another server

[dpm1234]

I'd like to create a trigger on a table in db1 that is located on server1, that will insert a row into a table in db2 on server2. Something like:

insert into svr2.db2.dbo.table2 ....

Anyone have any ideas?

 

[ClaireHCM]

Try this...but I didnt test it

First of all,create linked server which connect to svr2

Then in the Srv1.db1 database execute the following query

Create Trigger tr_itable1 on table1 for insert
as
insert into srv2.db2.dbo.table2 select * from inserted

 

[dpm1234]

That sounds great, but can you give me a tip on how to create a linked server?