Fields and Identity: Yes (Not for Replication)

[Amy]

Hi,
I have noticed the identity column option has 3 options (No, Yes, Yes (Not
For Replication).
I read the SQL help but am still struggling in understanding exactly what
would be best for my schema. Could someone please point me in the direction
of some articles on this or give me a different explanation of this option?
Thanks for your time,
Amy

[David Satz]

here is a start - http://sqlteam.com/item.asp?ItemID=2599

also, see http://vyaskn.tripod.com/repl_ans4.htm for replication info..

HTH,
Dave

"Amy" <akotsmith@idsgrp.com> wrote in message
news:3e9ed407$1@tnews.web.devx.com...
>
> Hi,
> I have noticed the identity column option has 3 options (No, Yes, Yes (Not
> For Replication).
> I read the SQL help but am still struggling in understanding exactly what
> would be best for my schema. Could someone please point me in the
direction
> of some articles on this or give me a different explanation of this
option?
> Thanks for your time,
> Amy
>

[Royce Bacon]

The Not For Replication option is used in databases where you are doing Merge
Replication and you are assigning specific Identify ranges to the various
sites. This option basically allows the replication process to keep the
original Identify value when it inserts a row instead of assigning a new
Identify value. This is critical if you have relationships with other tables
based upon the Identity field.



"Amy" <akotsmith@idsgrp.com> wrote:
>
>Hi,
>I have noticed the identity column option has 3 options (No, Yes, Yes (Not
>For Replication).
>I read the SQL help but am still struggling in understanding exactly what
>would be best for my schema. Could someone please point me in the direction
>of some articles on this or give me a different explanation of this option?
>Thanks for your time,
>Amy
>