| title | sp_helpdistributor_properties (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/03/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | replication | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | ee267724-3244-49eb-84c9-f38dbefdd639 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEappliesto-ss-asdbmi-xxxx-xxx-md]
Returns Distributor properties. This stored procedure is executed at the Distributor on the distribution database.
Transact-SQL Syntax Conventions
sp_helpdistributor_properties
| Column name | Data type | Description |
|---|---|---|
| heartbeat_interval | int | The maximum number of minutes that an agent can go without logging a progress message. |
0 (success) or 1 (failure)
sp_helpdistributor_properties is used with all types of replication.
Only members of the sysadmin fixed server role, members of the db_owner or replmonitor fixed database role on the distribution database, and users in the publication access list (PAL) for a publication that uses this Distributor can execute sp_helpdistributor_properties.