Tagged Questions

4
votes
1answer
70 views

How to reinsert corrected rows from the conflict table?

I have a bidirectional merge replication. I had failure constraints because the primary key was just integer. I change the primary key to the old primary key + a location identifier.The problem is how ...
0
votes
3answers
122 views

Merge Replication identity field issues

One of our clients is using our software with merge replication of a database on a SQL Server 2008 R2 machine. There are two production environments in separate geographical locations only one of ...
0
votes
1answer
99 views

SQL Server merge replication across domains

I'm getting the following message when trying to set up merge replication on SQL Server 2008 R2: The Merge Agent failed to locate the partitioned snapshot for this subscription in the expected ...
4
votes
1answer
127 views

The issue of sp_MScheckIsPubOfSub stored procedure

We have SQL Server 2008 R2 Merge replication set up. We have 20+ push subscriptions. Once in a while I get the following error message during the sync: Error messages: The merge process could not ...