SQL 2008 R2 Replication conflicts doesn't show up in Resolver

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL 2008 R2 Replication conflicts doesn't...

SQL 2008 R2 Replication conflicts doesn't show up in Resolver

Rate Topic

Display Mode

Topic Options

Author

Message

spidydotnet

Posted Thursday, October 11, 2012 10:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, May 04, 2013 3:54 AM
Points: 3, Visits: 63

Have a weird problem. I had to redo a merge publication where it was causing some issues. It was a simple rebuild and nothing was done differently. However, since that's done, any conflicts in any of merge publications, don't show up on the Conflict Viewer. When the conflict tables are queried, you can see the records.

Can someone help?

(SQL 2008 R2 is the publisher / distributor and Subscribers are SQL Server 2000.)

Post #1371685

spidydotnet

Posted Friday, October 12, 2012 9:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, May 04, 2013 3:54 AM
Points: 3, Visits: 63

There was a row in the sysmergearticles which had entries from previous publication. Soon after deleting that row, it started working. (posted the answer so it will be useful for someone)

Post #1372257

Darius T.

Posted Thursday, October 18, 2012 1:24 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 2:26 AM
Points: 7, Visits: 48

Hello,

How did You find that record in sysmergearticles ?

thanks

Post #1374172

« Prev Topic | Next Topic »

Permissions