Yes, DTC service is running on the remote server.

The local stored proc makes the call to the remote sp and when i execute that by itself, it works fine. The...