Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2008 R2 Replication conflicts doesn't show up in Resolver Expand / Collapse
Author
Message
Posted Thursday, October 11, 2012 10:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, May 4, 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
Posted Friday, October 12, 2012 9:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, May 4, 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
Posted Thursday, October 18, 2012 1:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 3:46 AM
Points: 7, Visits: 68
Hello,

How did You find that record in sysmergearticles ?

thanks



Post #1374172
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse