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
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
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:
Very valuable information. Thanks
Also I want to ask if you have any plans to make a virtual data room review or maybe a kind of comparison, or virtual data room pricing ? Is it your topic? If yes, I would like to know your opinion.
Thanks in advance!
Post a Comment