Re: Ran out of identity range
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Mon, 27 Jun 2005 21:22:17 -0400
do you mean you have run out of the identity range for the datatype? If so
you have to drop the subscriptions and the publication(s) which have the
article you are interested in fixing and change the data type.
For a new subscriber, it will get a new range when you deploy the snapshot.
For an old subscription modify the replication check constraint on the table
and run a DBCC checkident reseed. Then modify the value of max_identity in
distribution.dbo.MSrepl_identity_range
I would advise you to open a support incident with PSS for this kind of
problem.
--
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
"Vivek Sharma" <joe@xxxxxxxxxx> wrote in message
news:ux1M$m1eFHA.1448@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I have ran out of indentity range and I have a new PC to add. Is there
> anyway I can adjust the identity range and get to provide some identity
> range to the new PC?
>
> Thanks
>
> Vivek
>
>
.
- Follow-Ups:
- Re: Ran out of identity range
- From: Vivek Sharma
- Re: Ran out of identity range
- References:
- Ran out of identity range
- From: Vivek Sharma
- Ran out of identity range
- Prev by Date: Re: determine the assigned identity range
- Next by Date: Re: Replicate between SQL and Access
- Previous by thread: Ran out of identity range
- Next by thread: Re: Ran out of identity range
- Index(es):
Relevant Pages
|
