We are facing below error while configuring PUBLICATION on PROD (SQL 2008) server (P2P TRANSACTIONAL REPLICATION).
"This table cannot be published because it does not have a primary key column. Primary key columns are required for all tables in transactional publications."
In PROD server, some tables doesn't have primary key values and because of this we are facing above error.
Just I want to know from MS SQL experts, is there any other alternative solution for publishing tables that doesn't have primary key columns in P2P TRANSACTIONAL REPLICATION.
I believe using merge replication we can achieve above goal but is it possible using P2P transactional replication?
Please share your comments on the same.