Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-12-13 : 08:22:20
teju writes "When I do the snapshot replication, I am getting an error as follows ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'fkMemberEnBK'. The conflict occurred
in database 'repl_abc', table 'Groups', column 'Ps'.
(Source: Tserver (Data source); Error number: 547)

So, the distribution agent failed.

how can I resolve this problem?"

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-12-13 : 20:07:06
my guess is that you have a relational restriction for the articles (tables) involved and the relationship is also set for replication, uncheck that option and try again.

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -