SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Distributed transaction strange problem
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

netzorro
Starting Member

6 Posts

Posted - 01/16/2013 :  16:39:45  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000