How to configure a Distributor (Transact-SQL)

To configure a Distributor

  1. Execute sp_adddistributor at the server to be the Distributor.
  2. Execute sp_adddistributiondb at the Distributor to create a new distribution database.
  3. Execute sp_adddistpublisher at each server to be a Publisher that uses the Distributor.
See Also
Using the Create Publication Wizard to Configure a Distributor sp_adddistributiondb
sp_adddistpublisher sp_adddistributor

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.