How to avoid MSDTC in linked query

As we all are aware of linked servers and how to use it
We can use it to query remote server as well as copy data from one server to other server
Till now if we want to execute procedure on remote server and insert data on to local server using linked server we need MSDTC enabled on the server

Let see with example

We are inserting data into table tran_test from linked server

insert into tran_test
exec  [].[master].[dbo].[exec_test]

In SQL 2008 onwards we have new option available to disable MSDTC

As we can see once we disable "Enable Promotion of Distributed Transaction"
we can insert data without getting problem of MSDTC


Post a Comment

Popular Posts