<savvaschr@nodalsoft.com.cy> wrote in message
news:1162204073.520161.198100@m7g2000cwm.googlegroups.com...
> Hello
>
> I have a database of 52 replicated tables .
> I am using several filters on my Merge Replication and I can
> synchronize my handhelds just fine.
>
> The problem is that after some updates of the my main database(SQL
> 2005) when i try to synch the handhelds i get an 28549 error for a
> table.
>
> This table has a FK on another table.Is there a posibility that this
> table is updated earlier during the synch. than its 'Parent" table and
> thats why i am geting this error?
>
> Curently my setting of this table FK (and of all my tables are)
>
> Enforce for replication : YES
> Enforce foreing key constrain YES
> Insert anbd update specification
> deletion rule : no action
> update rule : no action
>
> If I set the Enforce foreing key constrains to NO will this solve the
> issue?
>
> Thanks
>
> Savvas Christodoulou
>
>
> PS: SQL 2005
>

Thanks for the answer but i have a question , you wrote

<savvaschr@nodalsoft.com.cy> wrote in message
news:1162910487.598320.102570@h48g2000cwc.googlegroups.com...
> Hi Again
>
> My Settings now in all table foreign keys are
>
> Enforce for replication : NO
> Enforce foreing key constrain YES
> Insert anbd update specification
> deletion rule : no action
> update rule : no action
>
> And the "Not For Replication in All Identity columns" is set to YES
>
> And I still get the Error !!!!! Any ideas?
>
> Shall I Also Put the
>
> Enforce foreing key constrain From YES to NO
> Is this has to do with Replication or with the Database itselfe.
>
> Thanks
>

<savvaschr@nodalsoft.com.cy> wrote in message
news:1162913494.630767.26830@m7g2000cwm.googlegroups.com...
> Thanks for the answer but i have a question , you wrote
>
> "If you are using merge replication you should disable this as it can
> prevent
> errors due to ordering of DML, i.e. a child row arriving before the
> parent
> row. "
>
> I am using Merge Replication and i have dissabled the "Enforce for
> replication"
> "Enforce for replication=NO"
>
> My Question is , shall i do the same with the
> "Enforce foreign key constaints" ????
>
> I also set the Not For Rwplication = YES
>
> But the problem is again there.
>