In one of our environments, we have a cluster with two active-active nodes with one SQL Server instance in each one.During this week, a fail of the service occurred in one of the nodes, which caused a failover to the node…
Error updating table with rowguidcol
In one of our environments, we have two SQL Server 2008 R2 DB aligned together by Peer to Peer replication, and each of the databases have a Merge replication with multiple subscribers. When we try to make an update on a article/table…
How to know which tables are replicated?
Sometimes you need to know all the tables that are replicated in a DB, for that use this scripts, run it in the replicated DB:
Conflict Resolutor Error
We found an error in Merge replication that im going to describe: When a Subscriber SQL Server 2005 Express replicates against a Publisher SQL Server 2008 R2 with a publication that has filtered articles, the option use_partition_groups set to true and…