Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  The Microsoft Distributed Transaction Coordinator

Author  Topic  jodman Starting Member 2 Posts Posted - 2010-05-20 : 08:34:59 Hi All. I apologise in advance if this post belongs in another section. Can anyone suggest why the following code within a trigger is being cancelled by the DTC on our production server? select Inserted.id, Table2.id from Inserted left join LinkedServer.dbo.Table2 on Inserted.id = LinkedServer.dbo.Table2.id where LinkedServer.dbo.Table2.ID is null The exact same code works without a problem on our testing server. The problem seems to be related to the use of NULL values because if i do an inner join the code executes without a problem and if i do a left join where table2.id is not null the code again works without a problem. I'm really struggling here; has anybody come across a similar issue before?