"Vivek Sharma" <joe@bloggs.com> wrote in message
news:ux1M$m1eFHA.1448@TK2MSFTNGP14.phx.gbl...
> 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
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:OQ6gU$3eFHA.584@TK2MSFTNGP15.phx.gbl...
> 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@bloggs.com> wrote in message
> news:ux1M$m1eFHA.1448@TK2MSFTNGP14.phx.gbl...
>> 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
>>
>>
>
>