Displays or changes publisher properties for non-Microsoft SQL Server Publishers. This stored procedure is executed at the Distributor.
sp_publisherproperty is used in transactional replication for non-SQL Server Publishers.
When only publisher is specified, the result set includes the current settings for all properties that can be set.
When propertyname is specified, only the named property appears in the result set.
When all parameters are specified, the property is changed and a result set is not returned.
When changing the xactsetjobinterval property for a running job, you must restart the job for the new interval to take effect.