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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-10 : 09:16:26
|
Stephen writes "We use SQL Server 7 SP2 at multiple sites, and replicate large amounts of data between them.
Every now and again, replication fails with a primary key violation. This is strange, as the key is valid in the primary database, but fails replicating to the target (which is of identical structure).
We wonder if SQL Server is trying to update rows at the target via an insert command, so fails because the key already exists.
I understand there is an SP that fixes replication problems. Do you know if this is an identified bug that has been addressed? It's a major issue, as we have to unwind and reinstate relication each time.
Thanks." |
|
|
|
|
|
Replication failing on updates