Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-06-15 : 06:13:46
|
| Hi all,I've got transactional replication set up between two servers.I'm getting the following error message:Violation of PRIMARY KEY constraint 'pk_instrumentArchive'. Cannot insert duplicate key in object 'rds.instrumentArchive'. The duplicate key value is (62434, 0). (Source: MSSQLServer, Error number: 2627)However when I look in the subscriber database I can see no row in the table with this primary key value?What could be causing this error? |
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2011-06-15 : 06:36:44
|
| Could it be that the dupicate key value specified in the replication monitor is incorrect? |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-15 : 10:04:36
|
| Either, the key value already exists, or you're trying to insert it twice in the same batch. |
|
|
|
|
|
|
Replication - Primary Key Violation