Replication of SPs

Hello everybody,
Does anybody know why SQl Server replication creates lots of other SPs while
creating real SPs, and all the names are like "sp_MSdel_MyTableNames", that
sp_MSdel_ part is repeated in all of them.
Thanks,
Mathew
These are replication stored procedures which the distribution agent uses to
apply the commands that form the transactions on the subscribers.
The naming convention is used to indicate the article (MyTableNames) which
they are used for, the purpose (upd, del, ins) and ownership (MS).
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mathew" <Mathew@.discussions.microsoft.com> wrote in message
news:62E5A659-2AEC-4D09-98D2-9D6369C728FD@.microsoft.com...
> Hello everybody,
> Does anybody know why SQl Server replication creates lots of other SPs
> while
> creating real SPs, and all the names are like "sp_MSdel_MyTableNames",
> that
> sp_MSdel_ part is repeated in all of them.
> Thanks,
> Mathew
|||By default, transactions are applied to the subscriber by using
parameterized stored procedures. So, you will get 3 procs created for each
table that you are publishing (sp_MSins, sp_MSupd, and sp_MSdel). The
sp_MSins procs are for inserts. The sp_MSupd procs are for updates. The
sp_MSdel procs are for deletes.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Mathew" <Mathew@.discussions.microsoft.com> wrote in message
news:62E5A659-2AEC-4D09-98D2-9D6369C728FD@.microsoft.com...
> Hello everybody,
> Does anybody know why SQl Server replication creates lots of other SPs
> while
> creating real SPs, and all the names are like "sp_MSdel_MyTableNames",
> that
> sp_MSdel_ part is repeated in all of them.
> Thanks,
> Mathew