saidapurs (8/22/2012)
Hi Mistihad,Replication will happen on 2 major condition.
1. Table should be required a index (Cluster or non-cluster)
2. Table structure should be same on Publish & subscriber.
Replication will happen on Table level not DB level as of my knowledge.
Thanks & regards
Satish
Point # 1 should be a primary key. Indexes are not a necessary condition as far as I know. Can you elaborate the first point please.
Chandan