Groups | Blog | Home
all groups > sql server replication > july 2005 >

sql server replication : sp_MSUPD query


SteveH
7/26/2005 3:07:04 AM
I am replicating via the sp_MS* procedures. Replication works fine for
inserts where sp_MSins_<tablename> is executed, but I have errors when
updating, since the same insert proc is called rather than the
sp_MSupd_<tablename> proc. I have checked the article details many times. The
system should definitely be calling the update routine rather than the insert
routine. Has anyone else observed this problem before ???
--
With Thanks
SteveH
7/26/2005 3:24:03 AM
Sorry (Raised in Error) - Sorted the problem - Someone had modified the
underlying sp_MSIns routine to include an additional insert

Problem rectified - Sorry for any inconvenience
--
With Thanks
SteveH


[quoted text, click to view]
AddThis Social Bookmark Button