Inserting To A Local Table From A Linked Stored Procedure

I have a sproc that is called from .net code which does an update on a local table and then is supposed to insert to a different local table values that are obtained from a remote

Solution 1:

one of the sql guys was able to resolve this by changing the "enable promotion of distributed transactions" to false.