Hi All,

I have created a replication for single database with 6 publications

Now when I am executing snapshot for particular publisher its blocking all other publication

And  frequently I am getting following error

The INSERT statement conflicted with the FOREIGN KEY constraint

• Edited by ImranKazi Tuesday, February 17, 2015 10:09 AM

Hi ImranKazi,

According to your description, you come across conflict error related with the FOREIGN KEY constraint when configuring replication. Based on my research, this issue could occur when there are foreign key constraints at publisher and subscriber that are not marked as NOT FOR REPLICATION.

To work around the issue, you could mark foreign key constraints as NOT FOR REPLICATION at publisher and subscriber, or specify a value of No for Enforce For Replication.

Regards,
Michelle Li