Replication problem(integrity violation) - Cannot Sync up emulator -HELP!! -- sql server replication

steroche
8/28/2005 3:41:33 PM

Can somebody help please - i keep getting this erro when trying to sycn
up my emulator to my Merged Replication DB.

"The row update or insert cannot be reapplied due to an integrity
violation. [,,,,,]"

Anybody know what this problem could be? I have recently dropped an
recreated a lot of my tables and changed some data types but did not
think it would effect me this badly.

I have also disabled and re-enabled my merge replication db many times.
I am sure all my connection settings are correct and the problem
appears to be deeper than that.

Recently i have changed the constraint on all of my tables to "Not to
enforce relationships on insert / update". It seems like this is what
the emulator is trying to do though??

Suggestions GREATLY appreciated!!!!
Thanks,
Steve

Hilary Cotter
8/29/2005 11:56:45 AM

When you disable these constraints it means they will be fired twice.

The first time do to the originating action, the second time due to the
replicated command. This is probably not what you want unless you do not
have cascading updates and deletes on your subscriber.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

sql server replication : Replication problem(integrity violation) - Cannot Sync up emulator -HELP!!