Why is a remote, searched UPDATE statement not completely evaluated remotely?

You can check elements of the SET clause and search condition to determine why a remote, searched UPDATE statement is not completely evaluated remotely.

Considerations:
  • Can the SET clause be completely evaluated at the remote data source? In other words, does an update expression contain a function not supported by the remote data source?
  • Does the SET clause involve a scalar subquery? Does the data source allow this syntax?
  • Can the search condition be completely evaluated at the remote data source? If the answer is no, examine the search condition instead.
  • Does the search condition or SET clause reference the target table? Does the data source allow this syntax?
  • Does the search condition or SET clause reference the target table with correlation? Does the data source allow this syntax?