SQL Server sp_showpendingchanges is used to determine how many changes need to be moved to a subscriber or uploaded to a publisher. You can use these steps to “roll your own” and pull similar data. To tackle this problem from the meta data can be a bit daunting, but there are some ways to get
Read More »
We encountered an unusual timing problem while pushing a Snapshot down to a merge subscriber. We don’t expect many to encounter this problem, after all we’ve only seen it once in 15 years. We wanted to share this as a learning opportunity as it illustrates a classic application\thread synchronization problem. Scenario Customer has Merge Replication
Read More »
In 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 procedures. This
Read More »
By José Moreira B. Neto Microsoft SQL Server Escalation Services Bounded Update is the term used to describe certain types of UPDATE statements from the publisher that will replicate as DELETE/INSERT pairs on the subscriber. We perform a bounded update for every set based update that changes a column that is part of a unique
Read More »
While troubleshooting customer’s Replication scenarios we often ask for the “script” used to recreate their replication environment. The BLOG posting below by Chad Miller provides a great example of using Power Shell and Replication Management Objects (RMO) to script out Replication. Click here for link to Quickly Script Out Replication Redux Written on August 2,
Read More »