Re: Ran out of identity range
- From: "Vivek Sharma" <joe@xxxxxxxxxx>
- Date: Tue, 28 Jun 2005 14:48:51 +1200
My problem is that SQL server identity range is 2147483647 and I have
reached 2147483600. Now I have a new PC and I cannot allocate the range to
it since I am left with only 47. How do I fix the problem? One option I
have is that I export the current data to the new database with fresh
tables. Once I have done that I can recreate a new publication and then
reassign the identity range to the subscribers. Is there a better solution?
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:OQ6gU$3eFHA.584@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>>
>>
>
>
.
- References:
- Ran out of identity range
- From: Vivek Sharma
- Re: Ran out of identity range
- From: Hilary Cotter
- Ran out of identity range
- Prev by Date: Re: Replicate between SQL and Access
- Next by Date: RE: Start with full and tables later?
- Previous by thread: Re: Ran out of identity range
- Next by thread: Re: Ran out of identity range
- Index(es):
Relevant Pages
|
