I have transnational replication on PROD. suddenly we are getting consistency errors in replication because of update statement (not for delete and not for insert).
update command working as Delete/insert pair(deferred update) @ subscriber .
we made only one change recently , we dropped clustered index on that big table1 as part of troubleshooting prospective. we are getting these error on table1 as delete conflicted with reference constraint
solution : everyone says "DBCC TRACEON (8207, -1)"
but Why this is happening all of sudden? we didn't add any new unique constraints on this table1.