Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


SQL Server 2000

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.

Result Sets
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.

See Also




System Stored Procedures

© 2015 Microsoft