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 |
|
Norwich
Posting Yak Master
158 Posts |
 Posted - 2006-10-08 : 06:56:38
|
| HiI added a linked server(sql) to my sql box. Both boxes use Mixed mode security and are in the same domain. I have added users to my linked server (sp_addlinkedsrvlogin). I can query the linked server successfully and I can Update tables on the linked server without any hassles. I, however, CANNOT INSERT new records into a specific table on the linked server. I have created new tables in that db and can insert remotely with no quibblesI get the following error:Msg 7391, Level 16, State 1, Line 1The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]Never seen anything like it - bizzare!Any ideas on how I can tackle this?RegardsNThe revolution won't be televised! |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-10-08 : 07:10:01
|
| I found the problem.There's a freakin trigger on the table. I disabled it and everything is working fine.Triggers are the source of my misery!RegardsNThe revolution won't be televised! |
 |
|
|
|
|
|
Linked Servers DTC?