sp_changedistributor_property (Transact-SQL)

APPLIES TO: yesSQL Server yesAzure SQL Database (Managed Instance only) noAzure SQL Data Warehouse noParallel Data Warehouse

Changes the properties of the Distributor. This stored procedure is executed at the Distributor on any database.

Topic link icon Transact-SQL Syntax Conventions


sp_changedistributor_property [ [ @property= ] 'property' ]  
    [ , [ @value= ] 'value' ]  


[ @property = ] 'property' Is the property for a given Distributor. property is sysname, and can be one of these values.

Value Description
heartbeat_interval Maximum number of minutes that an agent can run without logging a progress message.
NULL (default) All available property values are printed.

[ @value = ] 'value' Is the value for the given Distributor property. value is varchar(255), with a default of NULL.

Return Code Values

0 (success) or 1 (failure)


sp_changedistributor_property is used in all types of replication.


-- Change the heartbeat interval at the Distributor to 5 minutes. 
USE master 
exec sp_changedistributor_property 
    @property = N'heartbeat_interval', 
    @value = 5;


Only members of the sysadmin fixed server role can execute sp_changedistributor_property.

See Also

View and Modify Distributor and Publisher Properties
sp_adddistributor (Transact-SQL)
sp_dropdistributor (Transact-SQL)
sp_helpdistributor (Transact-SQL)
Replication Stored Procedures (Transact-SQL)