This seriously saved my ass. This is the only way to use an UPDATE with linked servers when you want to update only one column.

Thank you, thank you, thank...