Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

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...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc