sp_changedistributor_property (T-SQL)

Updates the properties of the Distributor.

Syntax

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

Arguments

[@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 go 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)

Remarks

sp_changedistributor_property is used in all types of replication.

Permissions

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

See Also