Replication - Should I set the Primary Key to No?

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,
BiancaIf you set it to 'Yes' , when the identity columns are transferred to the subscriber the identity property will not be transferred.

SQL requires that all identity columns use NOT FOR REPLICATION otherwise insert commands may not replicate properly

Originally posted by Bianca_J
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