February 18, 2009 at 6:02 am
Hi forum,
help out ,
The problem is when i replicate the primary server article on the copy of database article, it is replicating properly, but, if both the server database articles have the primary key clusted index, any changes or modifies the secondary database article, it's not replicating from primary to secondary db article. if i see the history its showing the error primary key voileted. i mean no changes from pulisher db to subcriber db.
are there any solutions except removing the primary key on the secondary db article.
manz
February 18, 2009 at 6:23 am
Try this,
1. Change secondary db article name and check.
2. Drop index on secondary db.
February 18, 2009 at 8:36 am
with transactional replication by default the replicas are "read-only" if you modify the replica table you will receive primary key violation errors.
If you expect to change data on the replicated tables then you must change your replication type.
* Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply