How to Connect the Different Server

---If it is Linked Server :
select * from openquery ([Servername]/*[servername]*/,'select * from ardata.dbo.CBRegion b with (nolock)
where ChannelID=''72''')
-------------------------------------------------
Select * from [Servername].databasename.dbo.tablename with (nolock) where id='72'
--- Servername.Databasename.Schema.tablename

---Open Row Setr
--OPENROWSET ( 'provider_name'
-- , { 'datasource' ; 'user_id' ; 'password'
-- | 'provider_string' }
-- , { [ catalog. ] [ schema. ] object
-- | 'query' }
-- )


SELECT a.*
FROM OPENROWSET('MSDASQL',
'DRIVER={SQL Server};SERVER=[servername];UID=Uname;PWD=PWD',
Ardata.dbo.hhproduct) AS a