IF EXISTS (SELECT srvname FROM master.dbo.sysservers srv WHERE srv.srvid != 0 AND srv.srvname = N'R_SERVER')
EXEC master.dbo.sp_dropserver @server=N'R_SERVER', @droplogins='droplogins'
GO
IF EXISTS (SELECT srvname FROM master.dbo.sysservers srv WHERE srv.srvid != 0 AND srv.srvname = N'R_SERVER')
EXEC master.dbo.sp_dropserver @server=N'R_SERVER', @droplogins='droplogins'
GO
EXEC master.dbo.sp_addlinkedserver @server = N'R_SERVER', @srvproduct=N'SQL', @provider=N'SQLOLEDB', @datasrc=N'10.4.234.123', @catalog=N'Demo'
GO
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'R_SERVER', @locallogin = N'', @useself = N'False', @rmtuser = N'sa', @rmtpassword = N'238173'
GO
SELECT * FROM R_SERVER.DBNAME.dbo.TABLENAME
