Trigger between database's error

[IanPike]

I have 2 SQL servers on a WAN, I have linked them as 'Linked Servers' and have set up a trigger on a table in one of the databases that when I insert into that table it writes the values inserted out to the other database.

However when I run a query to insert into the table I get the following message:-

The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

I know it sounds a bit like replication but once I get this working I want to go further than just copying entire tables etc.

I would appreciate any pointers anyone can give me.

Thanks in advance.