NFR needed in Foreign Key constraint?
From: Chris (Chris_at_discussions.microsoft.com)
Date: 02/28/05
- Next message: Hassan: "syncobj_0x?????"
- Previous message: Hilary Cotter: "Re: Third-party synchronous replication software"
- Next in thread: Paul Ibison: "NFR needed in Foreign Key constraint?"
- Reply: Paul Ibison: "NFR needed in Foreign Key constraint?"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Hassan: "syncobj_0x?????"
- Previous message: Hilary Cotter: "Re: Third-party synchronous replication software"
- Next in thread: Paul Ibison: "NFR needed in Foreign Key constraint?"
- Reply: Paul Ibison: "NFR needed in Foreign Key constraint?"
- Messages sorted by: [ date ] [ thread ]