USE [master]
GO
-- Start linked server deletion
PRINT 'Deleting existing linked servers...'
IF EXISTS ( SELECT 1 FROM sysservers WHERE srvname = 'ACCOUNT' )
EXEC master.dbo.sp_dropserver @

=N'ACCOUNT', @

logins='droplogins'
GO
IF EXISTS ( SELECT 1 FROM sysservers WHERE srvname = 'CHR01' )
EXEC master.dbo.sp_dropserver @

=N'CHR01', @

logins='droplogins'
GO
IF EXISTS ( SELECT 1 FROM sysservers WHERE srvname = 'RANKING' )
EXEC master.dbo.sp_dropserver @

=N'RANKING', @

logins='droplogins'
GO
-- End linked server deletion
-- Start linked servers creation
PRINT 'Creating new linked servers...'
exec sys.sp_addlinkedserver 'ACCOUNT', 'PUT YOUR SQL SERVER NAME HERE', 'SQLNCLI', @

name, null, null, 'ACCOUNT_DBF'
exec sys.sp_serveroption @

='ACCOUNT', @

name='rpc', @

value='true'
exec sys.sp_serveroption @

='ACCOUNT', @

name='rpc out', @

value='true'
exec sys.sp_addlinkedserver 'CHR01', 'PUT YOUR SQL SERVER NAME HERE', 'SQLNCLI', @

name, null, null, 'CHARACTER_01_DBF'
exec sys.sp_serveroption @

='CHR01', @

name='rpc', @

value='true'
exec sys.sp_serveroption @

='CHR01', @

name='rpc out', @

value='true'
exec sys.sp_addlinkedserver 'RANKING', 'PUT YOUR SQL SERVER NAME HERE', 'SQLNCLI', @

name, null, null, 'RANKING_DBF'
exec sys.sp_serveroption @

='RANKING', @

name='rpc', @

value='true'
exec sys.sp_serveroption @

='RANKING', @

name='rpc out', @

value='true'
-- End linked servers creation
IF @@ERROR = 0 PRINT CHAR(13)+'Linked servers creation was successful!'
ELSE PRINT CHAR(13)+'Linked servers creation failed!'