开发者

Why do I have duplicate rows for the same subscriber in my MSmerge_identity_range table?

开发者 https://www.devze.com 2022-12-08 00:37 出处:网络
I have a database with merge replication set up on a SQL 2005 server with 1 subscriber.I am having some identity range issues an I started to look at the MSmerge_identity_range table.I have one subscr

I have a database with merge replication set up on a SQL 2005 server with 1 subscriber. I am having some identity range issues an I started to look at the MSmerge_identity_range table. I have one subscriber but 2 rows for each. For Example(I shortend the guids but for arguments sake they are the same for each row):

subid artid range_begin range_end next_range_begin next_range_end is_pub_range max_used

FAD开发者_C百科8EA4E D8902F8E 1680378 1684378 1684378 1688378 0 NULL FAD8EA4E D8902F8E 1680378 2147483647 NULL NULL 1 1692379

Why are there 2 rows for one identity range for one subscriber? Thanks for your help.


The second row has "is_pub_range" flag set and its range_end is int.max, it seems to be used by MS code to determine a new range when the current range (e.g. the first row in your sample) exhausted.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号