question

ashok2012 avatar image
ashok2012 asked

why do primary key is essential in transactional replication?

Hi why do primary key is essential in transaction replication? Can we roll back changes of Security Patches upgrade in SQL Server?
interview-questions
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
As far as I've understood about transactional replication, the primary key is used by the replication mechanisms to find out which rows were changed. About patches: If you find a patch in Installed Updates in Control Panel, you can probably uninstall it from there.
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Perhaps you could elaborate on why you are not happy about the answers you got.
1 Like 1 ·
any other suggestions???????????????
0 Likes 0 ·
sjimmo avatar image
sjimmo answered
The primary key in replication is a unique key which is used by the publisher to find the record at the subscriber when a delete/update of a replicated record is performed.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jason_clark03 avatar image
jason_clark03 answered
The transactional replication requires a primary key constraint on each published table of a database. The merge replication doesn't need a primary key, but if there is one present, it must be replicated. Snapshot replication does not require a primary key.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.