declare @idMin bigint = 0
declare @rc int = 1
declare @cmd nvarchar(max)
              
select @rc = 1, @idMin = 0
while @rc>0 begin
    select top 1 @idMin = id from [dbo].a_activity ac order by id desc
    
    select @cmd = N'
select * from openquery(server2, ''select top 10000 * from dbo.activity with(nolock) 
where id>' + cast(@idMin as nvarchar(15))+ ' 
order by id'') oq'
    insert dbo.a_activity
    exec(@cmd)
    select @rc =@@rowcount
end    

declare @idMin bigint = 0;
declare @cmd nvarchar(1000);
              
select top 1 @idMin = id from dbo.a_activity ac order by id desc;
    
set @cmd = N'select * from openquery(server2, ''select * from dbo.activity where id>' + cast(@idMin as nvarchar(15)) + ''')';
--print @cmd;

insert dbo.a_activity
  exec(@cmd)