How To
How to Configure Publishing and Distribution (Transact-SQL)
- Execute sp_adddistributor at the server that will be the Distributor.
- Execute sp_adddistributiondb at the Distributor to create a new distribution database.
- Execute sp_adddistpublisher at each server that will be a Publisher using the Distributor.
On the master database on the Publisher, execute sp_replicationdboption for each database that will be a publication database.