replication set-up stored procedures -- sql server replication

MorDeRor
12/26/2006 9:06:00 AM

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

Hilary Cotter
12/27/2006 11:42:55 AM

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

[quoted text, click to view]

sql server replication : replication set-up stored procedures