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 Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
rambuyer
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?
You are not authorized to post a reply.

Acceptable Use Policy