Transact-SQL Reference
sp_changedistributor_property
Changes the properties of the Distributor. This stored procedure is executed at the Distributor on the distribution database.
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 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)
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.