Returns properties of the specified distribution database(s). This stored procedure is executed at the Distributor on the distribution database.
sp_helpdistributiondb [ [ @database = ] 'database_name' ]
[@database = ] 'database_name'
Is the database name for which properties are returned. database_name is sysname, with a default of % for all databases.
| 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.