deferred updates and transactional replication

Last Post 16 Jul 2004 07:24 AM by bayadba. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bayadba
New Member
New Member

--
16 Jul 2004 07:24 AM
Hello,

Has anyone encountered a problem with deferred updates and transactional replication with SQL Server 2000. I have some UPDATES that are replicated as DELETE followed by an INSERT even though UPDATE does not modify UNIQUE or CLUSTERED index. KB articles state that this (UPDATE replicated as DELETE / INSERT) should only happen when unique or clustered index key is modified.

Regardless of the cause i constantly get "ROW was not found at the subscriber" error, which is not true, because the row DOES exist on the subscriber.

Any ideas?

Thank you
You are not authorized to post a reply.

Acceptable Use Policy