Results 1 to 4 of 4

Thread: Replication Primary key

  1. #1
    Join Date
    Aug 2009
    Posts
    23

    Replication Primary key

    hello
    I am setting up transactional replication. And this is the first time I am doing this. I got to know that only the tables having primary key defined on them can be the part of this type of replication. But i am having hard time finding the reason that why is this so? I tried searching but everywhere it is given that it is mandatory but why it is mandatory is not given. So Can someone please let me know the reason for this.

    Regards,
    Narayan

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Sql is based on unique pkey values to apply transactions on subscriber.

  3. #3
    Join Date
    Aug 2009
    Posts
    23
    Thanks for ur reply!!! May be if u can elaborate a little, I ll get a better idea!!Thanks again

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Checked 'Advanced Replication Features and Internals' in books online?

Posting Permissions

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