tran replication

  • 1.why 'primary key' columns is required for implementing Transactional replication ?

    2.can we use only non-cluster indexes for implementing transactional replication

  • Because in the subscriber, update/delete is done using the primary key....

    The actual update/delete query that was executed on the publisher is not executed on the subscriber.

    Rows in the subscriber are updated/deleted one-by-one using the primary key in the WHERE clause.

    Therefore, primary key is required to identify the row.

    Hope this answers your question.

    Primary key can be non-clustered.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply