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 2008 Forums
 Transact-SQL (2008)
 Distributed transaction strange problem

Author  Topic 

netzorro
Starting Member

6 Posts

Posted - 2013-01-16 : 16:39:45
Hi, I've created a linked server in Windows 2003 with SQL2000 to Server2008 with SQL2008.
In the SQL2000 server a table has a trigger that inserts a value in a tabla in the linked server.
The first time I try to insert a value in the SQL2000 table I get:
--------------------
Server: Msg 7391, Level 16, State 1, Procedure pepe_trigger, Line 7
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
---------------------
But the second and subsecuent attemps work perfectly. The error is only the first insert I try. When I close the SQL Managmnt Studio and try again, same problem: Then first fails and after that everything works fine.

Any ideas?
Diego
   

- Advertisement -