IF NOT EXISTS (SELECT 1 FROM master.dbo.sysservers srv WHERE srv.srvname = N'MyLinkedServer')For SQL 2005
IF NOT EXISTS (SELECT 1 FROM sys.servers srv WHERE srv.server_id != 0 AND srv.name = N'MyLinkedServer')>what I need is to know if a specific SQL Server is linked to another SQL Server, if not link whit sp_addlinkedserver...