Category: Inside Replication

Distribution Agent is blocking users on Subscriber while replicating INSERT, UPDATE, and DELETE statements.

Share this PostIn the middle of a huge phased migration from SQL 2000 to SQL 2008 we noticed the SQL 2008 publisher\distributor was causing blocking when replicating data changes to the SQL 2000 subscriber. We discovered the SQL Server 2005\2008\2012 Distribution Agent was configured to replicate as native SQL commands instead of default parameterized stored
Read More »

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

Share this PostWe 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
Read More »