Year: 2012

Specify all articles when subscribing to a publication using concurrent snapshot processing.

Chris Skorlinski [MSFT] Troubleshooting April 4, 2012

I recently encountered this error when setting up Transactional Replication via SQL scripts. Msg 14100, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 533 Specify all articles when subscribing to a publication using concurrent snapshot processing. Looking at my create Publication script I see the default @sync_method = N’concurrent’ being set in sp_addpublication. Nothing I want
Read More »

Marking Identity Columns as “Not For Replication” in existing Publication

Chris Skorlinski [MSFT] Inside Replication March 5, 2012

We encounter a problem today with a Distribution Agent failing with “Row Not Found” when pushing an UPDATE to a Subscriber. Reaching the problem we discovered the Subscriber was created using a Backup\Restore from the Publisher and had Identity Columns. The Identity Columns had “Not For Replication” set to NO, which flags the Distribution Agent
Read More »