Post reply

Replication Query

  • June 16, 2004 at 9:00 am

    #162039

    Hi Guys,

    I am quite new to replication and have been asked a particular question.....and I was wondering whether the best SQL site (crawl, crawl) could point me in the right direction.

    Here goes:

    Two identical databases A and B. A is replicating to B.

    When verifying the data it appears the ID columns in the destination(subscriber) tables have not kept their original values and have reset. What could cause this?

    I would be grateful if any of you could give me a start point.

    Take it easy

    Graeme

     

  • June 17, 2004 at 6:06 am

    #510796

    Check that you have chosen the not for replication option for the identity column

  • June 17, 2004 at 9:42 am

    #510883

    If the id column of the published table an identity column?

  • June 18, 2004 at 4:57 am

    #510983

    Hi,

    The NOT FOR REPLICATION was indeed the problem.

    Thanks again for your input.

    Graeme

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply