Re: Managed vs. Automatic Identity Values

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 09/08/04 

Date: Wed, 8 Sep 2004 11:05:37 -0400

yes. Not For Replication is needed whenever you have any form of
bi-directional replication (except immediate updating where you don't need
it on the publisher).

It doesn't matter if you use automatic or manual strategies for identity
range management. 

-- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"JimMac" <JimMac@discussions.microsoft.com> wrote in message
news:D6B87EA5-57EC-438E-8FC3-59E8A9645CA0@microsoft.com...
> Does anyone know: if you go the Automatic ID Range handling method and let
> SQL Server do this via SP_Addmergearticle values of @auto, @thresh, etc.
>
> Are you STILL required to set the NOT FOR REPLICATION property on your
tables?
> or is that not needed? Is NOT FOR REPL ONLY if you go the manual method?
>
> Thanks much in advance
> Jim
> Boston USA

Relevant Pages

  • Re: Transactional replication from SQL Server 2005 to SQL Server 7 - how?
    ... SQL Server 7.0 from the SQL2005 management tools but I would encourage to ... primary keys are replicated as unique indexes if you ... configure replication using the SQL2000 Enterprise Manager. ... If you plan to reinitialize your SQL2000->SQL2005 subscription in the ...
    (microsoft.public.sqlserver.replication)
  • Re: High Availability
    ... also does failover. ... Async replication is real-time, as opposed to the scheduled Log Shipping ... > Note that one of the considerations for the active/passive GEO Cluster is ... > SQL Server 2000 High Availability Series ...
    (microsoft.public.sqlserver.clustering)
  • Re: Snapshot Creation
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The Microsoft AD account under which the Snapshot agent (and other ...
    (microsoft.public.sqlserver.replication)
  • Re: QUEUE READER - A FREQUENT PROBLEM!
    ... "Hilary Cotter" wrote: ... Looking for a SQL Server replication book? ... queue table and the same transaction coldn't be inserted at the ...
    (microsoft.public.sqlserver.replication)
  • Re: QUEUE READER - A FREQUENT PROBLEM!
    ... opinion what is the best choice: instal sp on sql server 2000 or install sql ... We are experimenting sql server 2005 replication making crash ... queue table and the same transaction coldn't be inserted at the ...
    (microsoft.public.sqlserver.replication)