Primary Keys are missing in Subscriber Tables
After db restore on Subscriber server, i configured transaction replication SQLServer 2005. then later few tables were added with Primary Key so that they can be part of replication, i ran the snapshot and everything went fine. When a bulk load test happend the process was too long, after investigation, i found the subscriber tables are not having the primary Keys, and it was doing full table scan.
I am bit confused here, how my Primary Keys are missing in Subscriber tables, which seems to me very odd. Any help or pointers would be much appreciated. Thanks...
Publisher table didn't had the primary key, after configuring replication, I've added the PK on publisher tables, then ran Snapshot which has added these tables in replication. When I am doing a simple data entry on those tables, the data is getting replicated to subscriber, but when I looked the table design, i am not seeing the PK (Clustered Index) on Subscriber (for those tables which got added after snapshot execution)
I am very glad to heve a response from Steve Jones, thanks much Steve.
Best Answer
If you had primary keys on the publisher tables from the start, they should have been put through when the tables were created on the subscriber. Did you let replication create the subscribed tables or were they manually created?
