| Dave Clausen 2005-06-25, 2:48 am |
| This looks like a DTC issue where a distributed transaction cannot be
established to execute your stored proc.
Here's a post which discusses enabling DTC:
http://groups-beta.google.com/group...8e4603d38d3ff44
Also, search for the KB article on what you need to do to loosen up DTC if
you're using Win XP.
Dave
"Rohan Sootarsing" wrote:
> Hi When I try to select a Stored procedure for biztalk to use I get this error
>
> Failed to execute SQL statement Please ensure that the supplied syntax is
> correct.The transaction manager has disabled its support for remote/network
> transactions.
>
> This Stored Procedure worked fine on my dev machine but can anyone shed any
> light to why i cannot use it for my live box
|