Unanswered: Merge replication and Publisher Identity range
I have configured a merge replicaiton on sql 2000.
I have also set up auto identity range management on one of my articles.
The publisher identity range is set to 600, and the subscriber identity range is set to 100 and the threshold is %80.My subscribers are mobile users connecting with pocket pc.
I have no problem with the pocket pcs, when they sync sql server automatically adjusts the identity range for them if they have used more than %80. However I have problems with managing identity range on the publisher. When I directly insert into the table on the publisher, if I use more than 80% of my keys, it won't adjust my identity range and it will give an error. I have to manually run the system stored procedure :"sp_adjustpublisheridentityrange" to adjust the range.
How can I automate this process? I read something about LogReader agent but I don't know how to start it?
Is there any way to handle this problem on the server side? Or do I have to run the stored procedure in my application?
The intellect is better than desire, for the intellect makes you a king over your destiny, and desire makes you a slave of your destiny.