views:

7

answers:

1

When I compare the sysmergesubscriptions table there are 5 entries, 1 for the publisher and 4 for the subscribers. I then look in the MSmerge_identity_range table and only see 2 records for each table that has managged identity ranges and the subid is the publishers is from sysmergesubscriptions. Shouldn't there be 1 record for each table for each subscriber in the MSmerge_identity_range table?

FYI: SQL 2005 Merge replicaiton 4 SQL 2000 subscribers Push replication

Thank you for your help

A: 

Here is what I have so far. The identity ranges for the subscribers are kept in the MS_Merge_Identity range tables on the subscribers not the one on the publisher.

Brian