exec sp_dropserver 'GenDev' GO exec sp_addlinkedserver @server = '{alias}' ,@datasrc = '{physical-server-name}' ,@srvproduct = '' ,@provider = 'SQLNCLI' GO