Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

MSmerge_identity_range_allocations (Transact-SQL)

The MSmerge_identity_range_allocations table is used to track the history of identity range assignments, to both Publishers and Subscribers, for published articles. This table is stored in the distribution database.

Column name

Data type

Description

publisher_id

smallint

The ID of the Publisher.

publisher_db

nvarchar(128)

The name of the publication database.

publication

nvarchar(128)

The name of the publication.

article

nvarchar(128)

The name of the article.

subscriber

nvarchar(128)

The name of the Subscriber.

subscriber_db

nvarchar(128)

The name of the subscription database.

is_pub_range

bit

Lists whether the identity range is assigned to a Publisher.

ranges_allocated

tinyint

The number of identity ranges assigned.

range_begin

numeric(38)

The starting value of the range.

range_end

numeric(38)

The last value in the range.

next_range_begin

numeric(38)

The starting value of the next range to be assigned.

next_range_end

numeric(38)

The last value of the next range to be assigned.

max_used

numeric(38)

The highest identity value used.

time_of_allocation

datetime

The time when the assignment was made.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.