Returns properties of the specified distribution database(s).
sp_helpdistributiondb [[@database =] 'database']
| Column name | Data type | Description |
|---|---|---|
| distribution_database | sysname | Name of the 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 | Not supported. |
| 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. |
sp_helpdistributiondb is used in all types of replication.
Execute permissions default to the public role.
| sp_adddistributiondb | sp_dropdistributiondb |
| sp_changedistributiondb | System Stored Procedures |