all groups > sql server replication > august 2003 >
You're in the

sql server replication

group:

Merge Replication Identity Range change


Merge Replication Identity Range change Nilay
8/7/2003 10:14:46 AM
sql server replication:
Hello,

I've Merge replication set up on SQL 2k SP3.
I've Identity range of 100 with 80% thershold on both
publisher & subscriber.

What is the best way to change Identity ranges &
thershold?. I tried doing it from Properties of
publication but looks like it is not reflecting properly.

Thanks
Nilay
Re: Merge Replication Identity Range change pheckz NO[at]SPAM hotmail.com
8/7/2003 6:39:34 PM
I did not know exactly what you meant but you can change the indentity
seed using "dbcc checkident".

-Pheckz

[quoted text, click to view]
Re: Merge Replication Identity Range change NIlay
8/8/2003 9:29:11 AM
Well, I wanted to the way so it gets changed at both
publisher and subscriber with different range than it is
now.

Thanks for your help.

Nilay
[quoted text, click to view]
Re: Merge Replication Identity Range change Karthik
9/29/2003 1:28:02 PM
Hi Nilay,

Go to Publication Properties and go into the articles tab.

Click on the elipse next to the table for which you want to set identity
values.

Go to Identity range and change accordingly.

Regards,
Karthik.



[quoted text, click to view]

AddThis Social Bookmark Button