Verifying linked server existense programmatically 1

[dobrios]

Hello there,
I need to programmatically create linked server and drop it in stored procedure.

I'm doing it using sp_addlinkedserver and sp_dropserver, but I get an error if there's already linked server with that name.
How do I check if linked server already exist, so I don't try to add it?

Searched Books Online, but no luck.
Thanks you

Steve

 

[mrdenny]

Try this out.

if exists (select * from sysservers where srvname = @ServerName)
BEGIN
   raiserror ('This server already exists.')
END
ELSE
BEGIN
   exec sp_addlinkedserver...
END

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[dobrios]

Thanks Denny,
That works like a charm.

 

[mrdenny]

no problem.

Denny

--Anything is possible. All it takes is a little research. (Me)