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.
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 7The 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 |
|
|
|
|