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