<div>
<div class="content wysiwyg-content">
We're developing an application using Visual Studio .NET (C#) and are working against a SQL Server database.<br />
One of our stored procedures makes use of a dynamic SQL cursor.<br />
In one instance we are working with data in one of the tables in the current database (where the connection is running) and in another we are accessing data from a linked server - i.e. SELECT -- FROM [SERVER2].Database1.dbo.Ta<wbr />ble1<br />
When we try and execute the stored procedure through C# code we get errors indicating that 'MSDTC on server SERVER1 is not available'.<br />
The code fails to complete.<br />
What are we missing ? &nbsp;(to allow the distributed query to run).<br />
Any help would be appreciated.<br />
Thanks, <br />
Steve
</div>
</div>


We're developing an application using Visual Studio .NET (C#) and are working against a SQL Server database.
One of our stored procedures makes use of a dynamic SQL cursor.
In one instance we are working with data in one of the tables in the current database (where the connection is running) and in another we are accessing data from a linked server - i.e. SELECT -- FROM [SERVER2].Database1.dbo.Table1
When we try and execute the stored procedure through C# code we get errors indicating that 'MSDTC on server SERVER1 is not available'.
The code fails to complete.
What are we missing ?  (to allow the distributed query to run).
Any help would be appreciated.
Thanks, 
Steve

Running SQL Stored procedure against a linked server

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).