This is a discussion on Updating linked server avoiding DTC within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Help!!! I have a problem updating field on an RDB linked server. The code I am running is: begin ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Help!!! I have a problem updating field on an RDB linked server. The code I am running is: begin tran update openquery(TAVNIOT, 'select TAVNIT, TAV_STAT from TAVNIOT where TAVNIT = 1') set TAV_STAT = 8 where TAVNIT = 1 commit The error I am getting is: Server: Msg 7391, Level 16, State 1, Line 2 The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a]. I understand the reason for that error but wondering, is there a way around it, such as avoiding the DTC? I tried setting the "Non transacted updates" on the linked server provider, with no results. The reason this is transacted is because the code must be run from a trigger. Help!!! |