January 13, 2009 at 11:51 am
I am trying to set up transactional replication. I have one database where there are certain tables(user tables) that we want to replicate to other servers. I set up the publication and everything seems to be fine and the creation of the subscription seems to be fine. However, when I look at the distributor to subscriber history I get an error:
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "Relation_232". The conflict occurred in database "db name", table "table name", column "column name". (Source: MSSQLServer, Error number: 547)
I have modified that constraint on the publishing database to "Enforce for Replication = No", but I am not sure why I am still getting this error after reinitializing the subscription and re-running the agent. I have also tried to delete the subscription and publication after making that change and it still doesn't seem to make a difference. Does anyone have any suggestions?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply