SQL Remote copies each INSERT or DELETE statement from the consolidated database transaction log, and sends them to each remote database that subscribes to the row being inserted or deleted. When only a subset of the columns in the table is subscribed to, the INSERT statements sent to the remote databases contain only those columns.

SQL Remote copies each INSERT or DELETE statement from a remote database transaction log and sends it to the consolidated database that subscribes to the row being inserted or deleted. The consolidated database then applies the statement, which results in writing to its transaction log. When the consolidated database transaction log is processed by SQL Remote, the changes are eventually propagated to the other remote sites. SQL Remote ensures that statements are not sent to the remote user that initially executed them.

• Duplicate primary key errors
• Row not found errors