--1.远程访问需要修改下本机（你用的这台，不是远程机）配置
exec sp_configure 'show advanced options',1    --默认是0
reconfigure

exec sp_configure 'Ad Hoc Distributed Queries',1  --默认是0
reconfigure

--2.可以对远程服务器进行查询，修改，删除等操作了
--查询
select * from opendatasource('SQLOLEDB','Data Source=123.123.123.123;User ID=sa;password=123456').DataBaseName.dbo.TableName
--添加
insert into opendatasource('SQLOLEDB','Data Source=123.123.123.123;User ID=sa;password=123456').DataBaseName.dbo.TableName (c1,c2) values ('123','321')
--修改
update opendatasource('SQLOLEDB','Data Source=123.123.123.123;User ID=sa;password=123456').DataBaseName.dbo.TableName set c2 = '222' where c1 = '123'
--删除
delete opendatasource('SQLOLEDB','Data Source=123.123.123.123;User ID=sa;password=123456').DataBaseName.dbo.TableName where c2 = '222'