SQL SERVER 之间 链接:
创建
exec sp_addlinkedserver 'ds' , '' , 'SQLNCLI10' , 'ip,1433'exec sp_addlinkedsrvlogin 'ds' , 'false' , null , 'sa' , '1111'
使用:
select * from openquery(ds,'select * from [tempdb].dbo.mytable1 ');
SELECT * FROM ds.[tempdb].dbo.mytable1 OK
SELECT * FROM dsfz1.[FY_ERP].dbo.mytable1 OK
SELECT * FROM dsfz1.[FY_ERP].dbo.mytable1 OK
删除:
Exec sp_droplinkedsrvlogin ds,NullEXEC sp_dropserver ds