sql server replication: Reset Next Range Starting Value? -- sql server replication

Reset Next Range Starting Value?

Jeff Hedlund
5/14/2005 7:56:48 AM

sql server replication:

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

Re: Reset Next Range Starting Value?

Hilary Cotter
5/14/2005 11:01:24 AM

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

[quoted text, click to view]