5 key sprocs used for replication

Can you please list 5-10 important sprocs being frequently called by the log
reader and distribution agent in a transactional replication setup and in
one line explain what they do ?
Thanks
Hassan,
have a look at this page in BOL:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
lref.chm::/ts_sp_00_519s.htm.
HIlary's book will explain the relevant ones, but I'd recommend
sp_addpublication, sp_addsubscription, sp_addarticle, sp_browsereplcmds,
sp_replcmds. I won't describe them as BOL does a good job already. To see
the key stored procs for your particular scenario, create the publication
and subscriptions in Enterprise Manager then get EM to script out the
publications and examine the scripts.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Actually I wanted to know the key sprocs that run once the transactional
replication is already setup. Sprocs that run that the log reader and
distribution agents call. Also any other sprocs that run on a constant
basis.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ucJXtws6EHA.3236@.TK2MSFTNGP15.phx.gbl...
> Hassan,
> have a look at this page in BOL:
>
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
> lref.chm::/ts_sp_00_519s.htm.
> HIlary's book will explain the relevant ones, but I'd recommend
> sp_addpublication, sp_addsubscription, sp_addarticle, sp_browsereplcmds,
> sp_replcmds. I won't describe them as BOL does a good job already. To see
> the key stored procs for your particular scenario, create the publication
> and subscriptions in Enterprise Manager then get EM to script out the
> publications and examine the scripts.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Hassan,
the easiest way to setermine these procs is to run profiler, trap the
relevant events (SP:Starting...) and then run the distribution agent.
Rgds,
Paul Ibison