I get error while I update a row in immediate updating subscription what is the cause?
Posted by Karthick P.K on September 15, 2010
Error:
{
Another user has modified the contents of this table or view; the database row you
are modifying no longer exists in the database.
Database error: ‘[Microsoft][ODBC SQL Server Driver][SQL Server]Updatable
Subscriptions: Rows do not match between Publisher and Subscriber. Run the
Distribution Agent to refresh rows at the Subscriber.
[Microsoft][ODBC SQL Server Driver][SQL Server]Updatable Subscriptions: Rolling
back transaction.’
}
In Transactional Replication with immediate updating subscription
Update to a row in subscriber which is already updated in publisher is not
possible.
When we update the row in subscriber it compares the value of msrepl_tran_version
in Publisher and subscriber. If it matches then update is allowed.
If msrepl_tran_version in Publisher and subscriber doesn’t match Update is not
possible for that row in subscriber.
This entry was posted on September 15, 2010 at 6:29 PM and is filed under Replication. Tagged: Another user has modified the contents of this table or view; the database row you are modifying no longer exists in the database, Replication, Transactional replication, Transactional replication fails. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
MSSQLWIKI 
http://journals.fotki.com/fofucha37/my-blog/ said
Amazing! Its genuinely remarkable piece of writing, I have got much clear idea regarding from this post.
southwest fragrances said
Howdy! This post could not be written any better!
Looking through this post reminds me of my previous roommate!
He always kept talking about this. I most certainly will forward this post
to him. Pretty sure he’s going to have a good read. Many thanks for sharing!
Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said
[…] I get error while I update a row in immediate updating subscription what is the cause? […]
this site said
Good ¡V I should certainly pronounce, impressed with your website. I had no trouble navigating through all the tabs as well as related information ended up being truly simple to do to access. I recently found what I hoped for before you know it in the least. Quite unusual. Is likely to appreciate it for those who add forums or anything, website theme . a tones way for your customer to communicate. Excellent task..