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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Problem deleting rows on subscriber in transaction

Author  Topic 

hendrasd
Starting Member

20 Posts

Posted - 2004-02-06 : 05:02:31
I set up a transactional replication with updating subscriber. But when I tried to delete a certain rows on the subscriber, It produced the following error message : 'Updatable Subscriptions : Rows do not match between publisher and subscriber.....'. I wonder what would be the cause of the problem ? Any suggestions on how to workaround it ? Thanks in advance ...

-- Never stop learning --

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2004-02-06 : 08:13:01
Depending on the "nature" of the table and replication options, the rows will be reinserted at the next replication.
Why do you want to delete the rows?
Go to Top of Page
   

- Advertisement -