I am getting this below error and i can't figure out why this is happening.if anyone has ever encountered this please suggest me on the same.
Error: 14151, Severity: 18, State: 1.
Replication-Replication Distribution Subsystem: agent ******** failed. There is already an object named 'Foriegn key name' in the database.
We are using Transactional up datable replication.This error occurring continuously.
I have checked the synchronization status.There i am getting message like "There is already an object named 'Foreign key name' in the database"
At Replication monitoring i am getting errors like
There is already an object named 'Foreign key name' in the database. (Source: MSSQLServer, Error number: 2714)
Get help: http://help/2714
Please advice on the same.