Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Washington D.C.
    Posts
    164

    Unanswered: Merge replication and Publisher Identity range

    Hi,
    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.

    Question:
    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.

  2. #2
    Join Date
    Dec 2002
    Location
    Washington D.C.
    Posts
    164

    Never mind, looks like this is a bug

    BUG: Identity Range Not Adjusted on Publisher When Merge Agent Runs Continuously

    http://support.microsoft.com/default...&Product=sql2k
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •