34,838
社区成员




if not exists (select a from master..sysservers where srvname=@Server)
begin
exec sp_addlinkedserver @Server,'SQLSERVER','SQLOLEDB',@Server
exec sp_addlinkedsrvlogin @Server,'false',null,@Uid,@Pwd
end
--你这里不是已经有判断了吗。不存在的时候才会去创建。。。
if not exists(select 1 from master.dbo.sysservers where srvname ='Analyse')
begin
exec sp_addlinkedserver 'Analyse','SQLSERVER','SQLOLEDB',@Server
exec sp_addlinkedsrvlogin 'Analyse','false',null,@Uid,@Pwd
end