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 Server Replication (Insert Conflict) Expand / Collapse
Author
Message
Posted Monday, January 17, 2011 12:20 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 2, 2012 3:44 AM
Points: 10, Visits: 45
The SQL Server Updateable Transactional Replication produce insert conflicts and the distribution agent running on the Subscribers stop working.

There is no conflict in identity since it is managed by publisher and identity ranges.

The conflict viewer didn't say the details of the conflict occured during insert

What is the cause of such a conflict?

How can I read the details of the insert conflict occured?
Post #1048902
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse