Monday, March 12, 2012

Replication 2 part update in SQL2005?

SQL2000 used to send a 2 part update using sp_msdel followed by sp_msins instead of just calling sp_msupd. I thought this used to happen on tables with compostie primary keys. Does any know know if this still occurs in SQL2005 and maybe why?

I think I found the answer as deferred updates, or Singleton pairs. See http://support.microsoft.com/kb/238254/en-us

No comments:

Post a Comment