"tperovic" <tonyperovic@yahoo.com> wrote in message
news:_bfLc.5403$iK.4645@newsread2.news.atl.earthlink.net...
> The following code:
>
> DECLARE @tsql varchar(1000)
> CREATE TABLE #Test (...)
> SET @tsql = 'SELECT * FROM OPENQUERY(MyDataSource, ...)'
> INSERT INTO #Test EXEC(@tsql)
>
> generates the following error message at the insert statement:
>
> Server: Msg 8501, Level 16, State 3, Line 4
> MSDTC on server 'MyComputer' is unavailable.
>
> Why?
>
> Thanks,
> Tony Perovic
> Compumation, Inc.
>
>

> Starting the DTC service caused the problem to go away but why does it
> need it?
>
>> DECLARE @tsql varchar(1000)
>> CREATE TABLE #Test (...)
>> SET @tsql = 'SELECT * FROM OPENQUERY(MyDataSource, ...)'
>> INSERT INTO #Test EXEC(@tsql)