-
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
-
Sql is based on unique pkey values to apply transactions on subscriber.
-
Thanks for ur reply!!! May be if u can elaborate a little, I ll get a better idea!!Thanks again
-
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
-
Forum Rules
|
|