SQL Remote relies on each database in the system having the same objects; when a table is altered at some sites but not at others, attempts to replicate data changes fail. Additional schema changes executed on a running SQL Remote system might cause problems.

Test your passthrough operations on a copy of the consolidated database with a copy of a remote database subscribed. Never run untested passthrough scripts on a production database.

Qualify object names with the owner name. PASSTHROUGH statements are not executed on remote databases from the same user name. Object names without the owner name qualifier may not be resolved correctly.