--启动DTC(分布式事务处理协调器) exec master..xp_cmdshell 'net start msdtc',no_output set XACT_ABORT on set ANSI_NULL_DFLT_ON on set ANSI_WARNINGS on BEGIN DISTRIBUTED TRANSACTION select * from OPENDATASOURCE('MSDASQL','DRIVER={SQL Server};SERVER=ip;UID=sa;PWD=密码;').pubs.dbo.jobs commit tran
exec sp_serveroption 'linkserver1', 'rpc', 'TRUE'
--设置链接服务器的rpc out选项为选中
exec sp_serveroption 'linkserver1', 'rpc out', 'TRUE'
--启动DTC(分布式事务处理协调器)
exec master..xp_cmdshell 'net start msdtc',no_output set XACT_ABORT on
set ANSI_NULL_DFLT_ON on
set ANSI_WARNINGS on BEGIN DISTRIBUTED TRANSACTION
select * from OPENDATASOURCE('MSDASQL','DRIVER={SQL Server};SERVER=ip;UID=sa;PWD=密码;').pubs.dbo.jobs
commit tran