Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    8

    Unanswered: 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,

    Bianca

  2. #2
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117

    Re: Replication - Should I set the Primary Key to 'No'?

    If 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
    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •