Hi, I have several Stored Procedures, which effectively do the same process, but on different linked servers. The linked servers are at remote locations which I access across the WAN. Each Stored Procedure deletes rows from a local table, and then inserts the results from a select statement. I have nested each of these Stored Procedures within another (Parent) Stored Procedure so that I have the choice of executing all of the (Child) Stored Procedures from the one parent Stored Procedure, or I could execute child Stored Procedures individually. I can successfully execute either the Parent, or any of the Child Stored Procedures. However, if attempt to execute the Parent Stored Procedure from within yet another Stored Procedure, I receive the following error: [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]. Msg 7391, Level 16, State 1, Procedure UserStoredProcedureName, Line 20 The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. I am not concerned whether the routine is executed from within a Transaction, so I have attempt to disable this, but still to no avail. The linked SQL Servers are only currently updated to Service Pack 3, and am wondering that if there is nothing wrong with what I am attempting to do, whether Service Pack 4 might solve the problem. Can anyone kindly offer any assistance?