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
 SQL Server Administration (2000)
 Replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-28 : 12:35:53
Narendra writes "I have got a publisher (which is also distributor) and a subscriber. I m opting for transactional replication with "immediate updating subscribers", the data from my publisher is replicated to my subscriber without any problems but when i try to update data at subscribers end it gives an error message saying "Another user has modified the contents of the table or view; the database row u r modifying no longer exists in the database. Database error : [Microsoft ODBC SQL Server Driver] could not change the Publisher because the subscription has been dropped. Use sp_subscription_cleanup to cleanup the trigger. Microsoft ODBC SQL Server Driver error couldnot relay results of procedure sp_Msync_UPD_PNR1 from remote server 'SQLOLEDB'.

i m not being able to update data at the subscriber end.

Please help as it is very very urgent !!!!!!!!!!!!!!"
   

- Advertisement -