Replication put Id column twice

• mmatseke

  Ten Centuries

  Points: 1129

  More actions

  June 25, 2004 at 6:01 am

  #360162

  Good day!

  I have a difficult problem, i have a merge replication which works fine, the problem comes when I have to update same table in ServerA and ServerB at the same time having Id being my identity column incrementing automatically.  Let me put this in a drawing

  insert into ServerA.Database.dbo.TableA

  (JobToExecute)

  values ('ISL_Name')

  insert into ServerB.Database.dbo.TableA

  (JobToExecute)

  values ('ISL_Surname')

  I get the following results

  Id     JobToExecute

  1      ISL_Name

  1      ISL_Surname

  ServerA is my conflicting server.  So I expect my results instead to only be

  1      ISL_Name

  Please take me step by step on how to resolve this since i am a newbie

   

   

   

• mmatseke

  Ten Centuries

  Points: 1129

  More actions

  June 25, 2004 at 6:57 am

  #511941

  I answered myself.  The problem is I didnt pu ID as Primary Key or Unique Constraint.  Thanks