开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜