SQL連接遠端數據庫方法

1.exec sp_dropserver 'srv','droplogins'
exec sp_addlinkedserver 'srv','','SQLOLEDB','172.16.20.11'
exec sp_addlinkedsrvlogin 'srv','false',null,'sjsqladmin','sql3125'
exec sp_serveroption 'srv','rpc out','true' 

select  top 10 *  from srv.CCLFawillHR312.dbo.emp1000c
exec sp_helpserver
select * from sysservers where srvname='srv'

2.select * from
 OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=172.16.21.166;User ID=sa;Password='
         ).pms.dbo.plan_index