November 22, 2009 at 11:50 pm
I am working on transaction replication configuration. The BoL states that whenever any transaction replication is configured then for every table three SPs are created namely SP_MSins_<tablename>; SP_MSupd_<tablename>;SP_MSdel_<tablename>. Eventhough I have configured replication but could not find these sps. I tried to find them in distribution DB but they are not there. Where they are created?
-Lucky
November 23, 2009 at 10:54 am
Ok this is not a well documented subject and I have oftened wonder why but here's my take on it but I would like to understand it a little more myself.
On your publisher run:
sp_scriptpublicationcustomprocs 'YourPublicationnamehere'
This proc will create the create script for the 3 procs you are talking about..
Take the script and apply it at the subscriber.. Replication will make calls to these procs based on the need so instead of replicating the command delete from yourtable.. it will call the stored proc instead to do the delete. Hope that makes sense.
Mike McNeer
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply