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 |
|
klegrand
Starting Member
29 Posts |
 Posted - 2006-03-27 : 04:58:36
|
| All,I'm getting the following error when I want to transfer data from one server to the other :Server: Msg 7391, Level 16, State 1, Procedure trgTest, Line 5The 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].This insert is on a table where the trigger uses to insert the data to the other server.If I'm using the same script of the trigger and run this in Query Analyser, than the the data is inserted. The MSDTC is running.What can be the solution for this ???Thx... |
|
|
|
|
|
Linked Servers Error