How to Configure Publishing and Distribution (Transact-SQL)

How to Install SQL Server 2000

How To

How to Configure Publishing and Distribution (Transact-SQL)

  1. Execute sp_adddistributor at the server that will be the Distributor.

  2. Execute sp_adddistributiondb at the Distributor to create a new distribution database.

  3. 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.