Sql Server Programming :: Help getting output from sproc to avoid DTC problem


	Help getting output from sproc to avoid DTC problem 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? TIA Curtis 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! -- TheSQLGuru President Indicium Resources, Inc. "Curtis" <curtmorri@hotmail.com> wrote in message news:1180540729.420975.173080@w5g2000hsg.googlegroups.com... - Hide quoted text - >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? > TIA > Curtis