MSDTC is unavailable...

[DLu]

I am selectively insert data from serverA databaseX to serverB databaseX.
(serverA is linked server on B.)

I could insert parent and child tables. But get error when insert to grand-child tables:
Server: Msg 8501, Level 16, State 3, Line1
MSDTC on server B is unavailable.

Don't think I need to turn on MSDTC on B. But I could copy and paste from source A server to target B server. Confusing on some table could insert while others with error....

thanks
-D

[rmiao]

Turn on MSDTC on server b then run the query again.

[DLu]

thanks for the info rmiao.

The DTC start failed and I remember that the target server is MSDE and it won't support DTC.

but find a way to select * into #temp and then from #temp to the target table.

still strange that MSDE allow remote linked server to insert top parent and child tables but request DTC on all the grand-child tables.

-D