Steps to perform Transactional Replication for tables with no primary key

How do I perform transactional replication for table with no primary key?

asked Jul 31 '12 at 04:54 PM in Default

Chitrarekha
140 ● 4 ● 21 ● 38

(comments are locked)

1 answer:

You don't.

Transactional replication cannot be performed on tables without primary keys.

Either add a primary key or use snapshot replication.

answered Jul 31 '12 at 05:20 PM

SirSQL
4.6k ● 1 ● 3

(comments are locked)

Your answer

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Topics:

asked: Jul 31 '12 at 04:54 PM

Seen: 267 times

Last Updated: Jul 31 '12 at 05:20 PM