Hi,
try this
insert into SourceServer\instance.Database.Table
select * from DestinationServer\instance.Database.Table with (nolock)
Or
you can establish a connection via linked server or using SSIS or some other integration tool. Once that link is established, you can use the form
insert into dbo.mytable
select * from [LinkedServer].[Database].[Schema].[Table]