Export (0) Print
Expand All
Expand Minimize
3 out of 3 rated this helpful - Rate this topic


SQL Server 2000

Adjusts the identity range on a publication and reallocates new ranges based on the threshold value on the publication. This stored procedure is executed at the Publisher on the publication database.


sp_adjustpublisheridentityrange [ @publication = ] 'publication'
    [ @table_name = ] 'table_name'
    [ @table_owner= ] 'table_owner'


[@publication =] 'publication'

Is the name of the publication in which the article exists. publication is sysname, with a default of NULL.

[@table_name =] 'table_name'

Is the name of the table. table_name is sysname, with a default of NULL.

[@table_owner =] 'table_owner'

Is the name of the owner of the Subscriber table. table_owner is sysname, with a default of NULL.

Return Code Values

0 (success) or 1 (failure)


sp_adjustpublisheridentityrange is used in all types of replication.

For a publication which has the auto identity range enabled, the Distribution Agent or Merge Agent is responsible for automatically adjusting the identity range in a publication based on its threshold value. However, if for some reason the Distribution Agent or Merge Agent has not been run for a period of time, and identity range resource have been consumed heavily to the point of threshold, users can call sp_adjustpublisheridentityrange to allocate a new range of values for a Publisher.


Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_adjustpublisheridentityrange.

See Also

Managing Identity Values

System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.