Topic: Insertion of the data from the coherent server
There is a task in which it is necessary to interpose into the given table the data from the coherent server.
For unification it decided to fulfill insertion procedure on the initial server, the request should look approximately so
INSERT INTO dbo. SourceTable EXEC [linkedServer]. [dbName].Scheme. [StoreProcedure]
Where StoreProcedure returns 1 data set
Request in a format
INSERT INTO dbo. SourceTable SELECT * from [linkedServer]. [dbName].Scheme. Table
Works without problems, and about usage error Distributed transaction falls out.
Can explain why so happens. And so to get rid of an error.