From: Toni on
We are currently using SQL Server 2008, I have 5 tables I would like to add
to the publication. We have one publisher and one subscriber. All 5 tables
exist on both the publisher and subscriber. Based on what I have read with
in BOL, to add an article I can go to the publication properties and check
the tables I want to add. My concern is the tables do have foreign Keys
defined both on the publisher and subscriber and am wondering if the order
they are added to the publication should be specified or if SQL will
determine the order based on the FK

Thanks
Toni

From: Toni on

I forgot to mention we use merge replication.


"Toni" wrote:

> We are currently using SQL Server 2008, I have 5 tables I would like to add
> to the publication. We have one publisher and one subscriber. All 5 tables
> exist on both the publisher and subscriber. Based on what I have read with
> in BOL, to add an article I can go to the publication properties and check
> the tables I want to add. My concern is the tables do have foreign Keys
> defined both on the publisher and subscriber and am wondering if the order
> they are added to the publication should be specified or if SQL will
> determine the order based on the FK
>
> Thanks
> Toni
>
From: Paul Ibison on
This should help explain: http://support.microsoft.com/kb/307356
HTH,
Paul Ibison