Sorry if I am a little naive here, but if both of the databases are on different networks could you not create a VPN from the "copy from" network to...

Sometimes, especially in a VM env, the firewall can cause these problems. In the firewall on the server allow it to open port 1433, what SQL SErver uses to listen...

Here is the basic Syntax:

update table1

SET serverowner = (

select serverOwner

from table2

where table1.servername = table2.servername

)

where servername in (select servername from table2)

GO

Sorry for the late reply, I overlooked some older emails...