Posted - 01/16/2013 : 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.