>If I understood you correctly now, you can create in your server a linked server to the one that has the correct data, then you can just use it in an update statement, something like
>
>

>update yourDB.yourSchema.YourTable
>set YourField = o.YourField from YourDB.YourSchema.YourTable m
>join  [theOtherServer\theOtherInstance].YourDB.YourSchema.YourTable o on o.pk = m.pk
>

>
>(Assuming the Schemas/Database also match, otherwise adjust as necessary.

I created a linked server. I tested the connection and it works. But, when I type it in the query it does not want to recognize it. I mean the intellisense doesn't kick in. It's like there is something I need to put in front of the linked server name.

In your example, what would be an example of theOtherServer and theOtherInstance?