Reset Next Range Starting Value?

Hello,
Is there any way to reset the "Next range starting value" on a table
with Identity Range management?
For some reason, the next range starting value has gone too high. The
maximum identity is 32767, and the next range starting value is 32650.
I did have the range size at subscribers set to 200, but there wasn't
enough room to give that range so the initial replication failed. I
changed it to 50 in order to get the initial subscription pulling.
The actual maximum identity in the table is less than 2000. I only
have 2 subscribers.
I'm not sure how it got so high, but is there a way to reset it?
Thanks,
Jeff
You can manually update the msrepl_identity (sp?) table in the distribution
database.
However, you should poll your subscribers and publisher to find out what is
in effect there.
Check the check constraint on the identity key and do a DBCC
checkindent('tablename') to get the current value and the value in use.
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
"Jeff Hedlund" <jhedlund@.gmail.com> wrote in message
news:1116082608.807565.267540@.o13g2000cwo.googlegr oups.com...
> Hello,
> Is there any way to reset the "Next range starting value" on a table
> with Identity Range management?
> For some reason, the next range starting value has gone too high. The
> maximum identity is 32767, and the next range starting value is 32650.
> I did have the range size at subscribers set to 200, but there wasn't
> enough room to give that range so the initial replication failed. I
> changed it to 50 in order to get the initial subscription pulling.
> The actual maximum identity in the table is less than 2000. I only
> have 2 subscribers.
> I'm not sure how it got so high, but is there a way to reset it?
> Thanks,
> Jeff
>