replication set-up stored procedures

Hello everyone,
I have two questions:
1. about sp_adddistributor - in the case when a remote distributor is being
used does it have to be run both at the publisher and at the distributor?
2. about sp_addsubscriber - where does it fit in the chain of replication
setup SPs? I have this sequence so far:
sp_adddistributor (@.distributor)
sp_adddistributiondb (@.distributor)
sp_adddistpublisher (@.distributor/@.publisher)
sp_replicationdboption (@.publisher)
sp_addpublication (@.publisher)
sp_addarticle (@.publisher)
sp_addsubscriber (@.publisher) is this the right point of execution?
sp_addsubscription (@.publisher)
thanks in advance
sp_adddistributor is run only on the distributor. You have a correct
placement for the add subscriber statement, but really it can be run anytime
after the distributor is created.
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
"MorDeRor" <MorDeRor@.discussions.microsoft.com> wrote in message
news:E505E5B2-6FDD-46A1-8D40-CD2D241A4B5C@.microsoft.com...
> Hello everyone,
> I have two questions:
> 1. about sp_adddistributor - in the case when a remote distributor is
> being
> used does it have to be run both at the publisher and at the distributor?
> 2. about sp_addsubscriber - where does it fit in the chain of replication
> setup SPs? I have this sequence so far:
> sp_adddistributor (@.distributor)
> sp_adddistributiondb (@.distributor)
> sp_adddistpublisher (@.distributor/@.publisher)
> sp_replicationdboption (@.publisher)
> sp_addpublication (@.publisher)
> sp_addarticle (@.publisher)
> sp_addsubscriber (@.publisher) is this the right point of execution?
> sp_addsubscription (@.publisher)
> thanks in advance
>
|||Hi Hilary,
I'm glad you picked up on this question. My confusion started from comparing
the EM generated scripts to the setup procedures described in your book where
I could not find the add subscriber stored procedure.
also, do I have to run grant access statements, or is there a default set of
rights that gets assigned to these objects that could be good enough?
Thanks
Mor
"Hilary Cotter" wrote:

> sp_adddistributor is run only on the distributor. You have a correct
> placement for the add subscriber statement, but really it can be run anytime
> after the distributor is created.
>
> --
> 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
>
> "MorDeRor" <MorDeRor@.discussions.microsoft.com> wrote in message
> news:E505E5B2-6FDD-46A1-8D40-CD2D241A4B5C@.microsoft.com...
>
>