sys.sp_adddistributor

Description

table (if there isn’t one), marks the server entry as a Distributor, and stores property information. This stored procedure is executed at the database to register and mark the server as a distributor. In the case of a remote distributor, it’s also executed at the Publisher from the , with no default. This parameter is only used if setting up a remote Distributor.

Syntax

sp_adddistributor
[ @distributor = ]
N
'distributor'
[ , [ @heartbeat_interval = ] heartbeat_interval ]
[ , [ @password = ]
N
'password'
]
[ , [ @from_scripting = ] from_scripting ]
[ , [ @encrypt_distributor_connection = ]
N
'encrypt_distributor_connection'
]
[ , [ @trust_distributor_certificate = ]
N
'trust_distributor_certificate'
]
[ , [ @host_name_in_distributor_certificate = ]
N
'host_name_in_distributor_certificate'
]
[ ; ]

Permissions

Only members of the fixed server role can execute. Configure Publishing and Distribution sp_changedistributor_property (Transact-SQL) sp_dropdistributor (Transact-SQL) sp_helpdistributor (Transact-SQL) System stored procedures (Transact-SQL) Configure Distribution