IF NOT EXISTS (SELECT srvname FROM sysservers WHERE srvname='SQL1-SERVER')
BEGIN
EXEC SP_ADDLINKEDSERVER 'SQL1-SERVER','','SQLOLEDB','192.168.1.10'
EXEC SP_ADDLINKEDSRVLOGIN 'SQL1-SERVER','FALSE',NULL,'sa',''
END
IF NOT EXISTS (SELECT srvname FROM sysservers WHERE srvname='SQL1-SERVER')
BEGIN
EXEC SP_ADDLINKEDSERVER 'SQL1-SERVER','','SQLOLEDB','192.168.1.10'
EXEC SP_ADDLINKEDSRVLOGIN 'SQL1-SERVER','FALSE',NULL,'sa',''
END