Maybe rather than post all the code (there are quite a few procs), I'll narrow my question down a bit.

When you're inside a transaction that is being governed by MTS/DTC,...

nod.

i'm using "set xact_abort on/off"

using sql server profiler, i have not been able to find any sql syntax errors.

this error is such a pain!