How to get around needing PK in Transaction Replic

• harim

  SSC Journeyman

  Points: 98

  More actions

  January 7, 2003 at 3:29 pm

  #79978

  Is there a way I can still perform Transaction Replication. Any way to get around the fact of not being able to use auto-generated ids?

  Thanks.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  January 7, 2003 at 3:34 pm

  #445796

  You have to have a primary key, not an identity col. You can use a natural key, identity of course, a uniqueidentifier along with newid().

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter