Luis Cazares (4/8/2014)
Eirikur Eiriksson (4/8/2014)
You should look into linked server, check this out😎
It could help in other cases, but I'm not sure that it's the best option if you're trying to copy all those rows. I'd prefer a process that can work in batches.
Good point, you are absolutely right, thanks for pointing this out.
😎