Currently we are in need of copying prod data to a test environment. This works fine with Transactional replication. The problem is when someone changes a data row in the test environment & then the same row is prod gets updated. Example: Prod Table has 3 columns ABC 123 ABC Test has the same ABC 123 ABC The test data now changes to: AAA 123 ABC The prod data now changes to: ABC 222 ABC It seems to break the replication with the following error: Error executing a batch of commands. Retrying individual commands. I would expect the data from prod to just do an insert if it cant find the row to update. It also stops all other transactions from being replicated. Any ideas?