Replication - Should I set the Primary Key to 'No'

• harim

  SSC Journeyman

  Points: 98

  More actions

  February 5, 2003 at 2:22 pm

  #58988

  Hello:

  If I would like to do Transactional Replication - do I set the Primary Key in the Table to

  Identity = 'No'

  Identity = 'Yes' or

  Identity = 'Yes (Not for Replication)'

  Thanks,

  Bianca

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  February 5, 2003 at 5:52 pm

  #448155

  It depends on how you are creating primary keys.

  If you are using the identity property to generate primary keys, then you should use 'Yes (Not for Replication)'.

  If your application is responsible for generating primary keys, then no is the answer.