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 |
|
sona
Yak Posting Veteran
68 Posts |
Posted - 2004-01-28 : 00:51:49
|
| I setup Transactional replication between two tables in two sqlservers A[master] and B.It started working without any problem.What i did was i inserted a record in B alone.Then i inserted the same Record in A.So at the scheduled synchronisation time, when the changes were propagated from A to B i got the Primary Key violation errror.And the Job failed .i am getting all the cross marks of failure in the Replication monitorNow i made another insertion to Table in A but it is not getting propagated.After any error how to make the replication continue ???? without recreating the subscription |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-28 : 12:17:53
|
| Have you restarted the replication job?Tara |
 |
|
|
|
|
|