locked
Merge replication Issues in sql server2008 RRS feed

  • Question

  • HI All,

     

      I has been implemented Merge replication in sql server 2008, in that some tables ID are (primary key and identetly Colums) are add 2000 and 20000 no add automatically incremented, why it was happens how to resolved this issues? if i want to get continues number what will it do, please help me in this ..... this is very urgent for me.

       

    Prasad

    • Moved by Tom Phillips Wednesday, November 17, 2010 1:27 PM Replication Question (From:SQL Server Database Engine)
    • Edited by SAAD's Tuesday, December 14, 2010 1:31 PM
    Wednesday, November 17, 2010 8:19 AM

Answers

  • Hi,

    You can run sp_adjustpublisheridentityrange to assign new identity rangs. For more information, please refer to Replicating Identity Columns (http://msdn.microsoft.com/en-us/library/ms152543.aspx).

    Thanks,
    Chunsong


    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, November 22, 2010 7:41 AM