Wednesday, March 28, 2012

How to assign different identity ranges to publisher and subscribers?

Hello,
There is a @.identity_range parameter, which controls the identity
range size initially allocated both to the publisher and to
subscribers in sql server 2005 merge replication. I need to assign
different identity ranges for publisher and subscribers. Is it
possible to achieve it? The @.pub_identity_range parameter does not
seem to work.
Thanks you,
Jawad
You can do it manually using checkident or using the create publication
wizard (see the article properties dialog, its in the identity range
management section).
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JDee" <jawwad.ali@.gmail.com> wrote in message
news:1174476685.219315.29270@.n59g2000hsh.googlegro ups.com...
> Hello,
> There is a @.identity_range parameter, which controls the identity
> range size initially allocated both to the publisher and to
> subscribers in sql server 2005 merge replication. I need to assign
> different identity ranges for publisher and subscribers. Is it
> possible to achieve it? The @.pub_identity_range parameter does not
> seem to work.
> Thanks you,
> Jawad
>

No comments:

Post a Comment