>At 2 linked-servers, i have this error message rigth after an insert statement.
>This doesn't happen if the "destiny table" doesn't have any triggers.
>
>Any idea?
>
>Server: Msg 7391, Level 16, State 1, Procedure IT_CONMA_ST, Line 18
>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. ]
Is the linked server a VFP DBC? If this is true then the problem might be the inability of VFP to enlist in automatic transactions with the MSDTC. Check out the article MTS for VFP developers at
http://msdn.microsoft.com/library/default.asp?URL=/library/techart/MTSVFP.htm