Is there an "IF EXISTS" test for a linked server? Is there an "IF EXISTS" test for a linked server? sql-server sql-server

Is there an "IF EXISTS" test for a linked server?


Check in sys.servers:

if not exists(select * from sys.servers where name = N'myserver\devdb_1')


IF NOT EXISTS ( SELECT TOP (1) * FROM sysservers WHERE srvname = 'myserver\devdb_1' )