NFR needed in Foreign Key constraint?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chris (Chris_at_discussions.microsoft.com)
Date: 02/28/05


Date: Sun, 27 Feb 2005 18:03:05 -0800


We are load testing one-way trans repl by replaying a profiler trace on the
publisher.

The subscriber was restored w/ a backup.

Distr agent failing w/ foreign key constraint errors.

We determined this was due to an update stmt coming across as a delete, then
insert. Is this profiler tweaking the update stmt, or is this replication
prompting the need for NOT FOR REPLICTION option on foreign key constraints?

Thanks in advance,
Chris