Is Microsoft phasing out identity columns as we knew them? I don't like having to permanently turn on a trace flag to get the same functionality that we were...

I found the answer. I had to create the subscriptions on both sides using sp_addsubscription setting @loopback_detection = 'false'. Thank you for all the advice and suggestions.

After increasing the output verbosity as suggested, looking at the replication system tables and adding a few triggers to track what was and wasn't happening to the replicated table on...

I caught some more data discrepancies with rows deleted from the publisher but not the subscriber. There was a corresponding command in sp_browsereplcmds for all 7 rows that weren't...

Thank you Jannie for the detailed response.

First, I don't have any filters on the subscription. All rows would have been delivered with the snapshot. The default agent profile...