--创建服务器
exec sp_addlinkedserver 'cwsrv_lnk','','SQLOLEDB','192.168.1.200'
--添加用户
exec sp_addlinkedsrvlogin 'cwsrv_lnk','false',null,'sa',''
--查询示例
select * from cwsrv_lnk.UFDATA_001_2008.dbo.GL_accvouch
--导入(插入)
select * into GL_accvouch from cwsrv_lnk.UFDATA_001_2008.dbo.GL_accvouch
go
--处理完以后删除链接服务器
exec sp_dropserver 'cwsrv_lnk','droplogins'
--方式2
SELECT * FROM OPENDATASOURCE('SQLOLEDB',
'Data Source=192.168.1.200;User ID=sa'
).UFDATA_001_2008.dbo.GL_accvouch