Remote for Select between two server in same lan netword

http://blogs.msdn.com/b/sql_protocols/archive/2006/08/10/694657.aspx

SELECT * FROM sys.servers

sp_addlinkedserver ADDR01

sp_addlinkedserver('servername')

EX run a sp: ADDR01.tempdb.dbo.sp_ServiceTask1SpecialSiteAppConfig

sp_addlinkedserver 'ADServerNew2013', '', 'SQLNCLI', NULL, NULL, 'SERVER=184.168.74.227', NULL

sp_addlinkedsrvlogin 'ADServerNew2013', 'false', NULL, 'sa', 'AD@ram123'

select * from ADServerNew2013.Staging.dbo.Scrape_DetailLinkRules

sp_help sp_addlinkedserver

sp_helptext sp_addlinkedserver

select * from sys.linked_logins

select L.*

from sys.linked_logins as L, sys.servers as S

where S.server_id=L.server_id

           and S.name=N'ADServerNew2013'

Other:

EXEC sp_addlinkedserver

@server        = N'ADServerNew2013',

@srvproduct = N'',

@provider     = N'SQLNCLI',

@provstr       = N'SERVER=184.168.74.227 ;User ID=sa;Password=AD@ram123'

EXEC sp_addlinkedserver

@server='APPLYDIRECTSTAG3',

@srvproduct='SQL Server',

@provider='SQLNCLI',

@datasrc='SQLB',

@provstr='Integrated Security=SSPI'