I have a stored procedure that returns a value from a linked server. I
am unable to enable remote DTC access on that server. The sproc
returns the correct value, but when I try to insert that value in to a
table, I receive the "unable to begin a distributed transaction"
message (Msg 7391). I'm trying to find a way to grab the output of the
sproc and throw it into a parameter - is there a way of doing this
that will avoid the DTC error?
can you use output variable, or is that what you are doing?
did you specify a begin tran? if so, try removing it.
or do a search on support.microsoft.com and jump thru the hoops to get DTC
working. It can be a PITA tho!
Indicium Resources, Inc.
@hotmail.com> wrote in message