Is it necessary to drop FK's on Subscriber?

Last Post 08 Mar 2004 08:04 AM by rambuyer. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

08 Mar 2004 08:04 AM
As a rule of thumb, my new company always drops the Foreign Keys in the subscriber when setting up transactional replication.

Is this necessary? My understanding is that we do this because we can't guarantee that the parent record will be replicated before the child record as SQL uses batches for Transactional Replication and the order within the batch is not certain.

Is this a practice that everyone uses with Transactional replication?

Acceptable Use Policy