急！如何判断链接服务器已存在，存在则删除

[hsanjin]

如何判断链接服务器已存在，存在则删除

--创建链接
EXEC sp_addlinkedserver 'LinkName','','SQLOLEDB','20.10.1.22'
EXEC sp_addlinkedsrvlogin 'LinkName','false',NULL,'sa','123'
-------------------------------------------------------------------------------------------------------------------------------
--删除链接
-------------------------------------------------------------------------------------------------------------------------------
EXEC sp_droplinkedsrvlogin 'LinkName',NULL
EXEC sp_dropserver 'LinkName','droplogins'

[claro]

--SQL2005
select *
from sys.servers
--SQL2000
sp_helpserver 'SQL2K'  --SQL2K指某个数据库名称

[feixianxxx]

[Quote=引用 2 楼 chuifengde 的回复:]

SQL code
select * from master..sysservers
where srvname='链接服务器名'
[/Quote]......

[bancxc]

if exists(select * from master..sysservers  where srvname='链接服务器名')
	EXEC sp_droplinkedsrvlogin 'LinkName',NULL

[Mr_Nice]

[Quote=引用 2 楼 chuifengde 的回复:]

SQL code
select * from master..sysservers
where srvname='链接服务器名'
[/Quote]
...

[jiangshun]

EXEC sp_helpserver

[chuifengde]

select * from master..sysservers 
where srvname='链接服务器名'

[wwwtyb]

declare @serverName varchar(20)
set @serverName='tyb'
if exists(select 1 from master.dbo.sysservers where srvname=@serverName)
begin
	EXEC sp_dropserver @serverName,'droplogins' 
end