USE master
if not exists (select * from master.dbo.sysservers where srvname='srv_kaoqindb')
begin
exec sp_addlinkedserver 'srv_kaoqindb','','SQLOLEDB','168.0.0.5'
exec sp_addlinkedsrvlogin 'srv_kaoqindb','false',null,'sa','sa'
end
/*
exec sp_droplinkedsrvlogin 'srv_kaoqindb' ,'sa'
exec sp_dropserver 'srv_kaoqindb'
EXEC sp_linkedservers
EXEC sp_catalogs 'srv_kaoqindb'
*/
select top 10 * from srv_kaoqindb.kaoqindb.dbo.kaoqintb
select getdate() as now
About linkedserver
最新推荐文章于 2021-10-13 13:46:18 发布