Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2007
    Posts
    8

    Unanswered: modify next identy range on replication

    This problem is about replication

    I have a publisher and a few suscribers running with sql 2003

    I use automatic range handling to manage some identity columns in some tables

    How can I manually modify the value of the next range that the publisher will assign to the next suscriber that need a range?

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    hi, is sql 2000 or 2005? what is the replication type? merge or transactional? thanks.

  3. #3
    Join Date
    Feb 2007
    Posts
    8

    Hello

    sorry, we use sql 2003, and transactional replication

  4. #4
    Join Date
    Feb 2007
    Posts
    8
    sorry agan, its sql 2000

  5. #5
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    ok, not is a good idea use identity fields in a replication. but, read this tn.
    http://www.sqlservercentral.com/colu...gehandling.asp
    and tell me.
    bye.

  6. #6
    Join Date
    Feb 2007
    Posts
    8
    Ok, thanks for you advice, i'll check the link out

Posting Permissions

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