.png)
sp_helpdistributiondb (Transact-SQL)
Returns properties of the specified distribution database. This stored procedure is executed at the Distributor on the distribution database.
Column name | Data type | Description |
|---|---|---|
name | sysname | Name of the distribution database. |
min_distretention | int | Minimum retention period, in hours, before transactions are deleted. |
max_distretention | int | Maximum retention period, in hours, before transactions are deleted. |
history retention | int | Number of hours to retain history. |
history_cleanup_agent | sysname | Name of the History Cleanup Agent. |
distribution_cleanup_agent | sysname | Name of the Distribution Cleanup Agent. |
status | int | Internal use only. |
data_folder | nvarchar(255) | Name of the directory used to store the database files. |
data_file | nvarchar(255) | Name of the database file. |
data_file_size | int | Initial data file size in megabytes. |
log_folder | nvarchar(255) | Name of the directory for the database log file. |
log_file | nvarchar(255) | Name of the log file. |
log_file_size | int | Initial log file size in megabytes. |
Members of the db_owner fixed database role or the replmonitor role in a distribution database and users in the publication access list of a publication using the distribution database can execute sp_helpdistributiondb to return file-related information. Members of the public role can execute sp_helpdistributiondb to return non-file-related information for distribution databases to which they have access.
