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 xxx.xxx.xxx.xxx


insert into tran_test
exec  [xxx.xxx.xxx.xxx].[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

2 comments:

Post a Comment

Amazon Contextual Product Ads

Popular Posts