Groups | Blog | Home
all groups > sql server replication > march 2006 >

sql server replication : not for replication


Jake
3/20/2006 9:21:13 AM
Hello,

Sorry for the stupid question but I am getting myself confused I guess.
Not hard since it's Monday. If I want merge replication to manage my
identities for autonumber columns on the subscriptions. Is the NOT FOR
REPLICATION set to YES or NO? Thanks.

Jake

Paul Ibison
3/20/2006 5:37:26 PM
Jake,
NFR should be set to Yes. Actually if you're using automnatic range
management, the wizard will change the identity column to be NFR if it isn't
set before adding the publication.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button