sp_helpdistributiondb (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns properties of the specified distribution database. This stored procedure is executed at the Distributor on the distribution database.

Topic link icon Transact-SQL Syntax Conventions


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 associated with the Distributor and on which the user has permissions.

Result Sets

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.

Return Code Values

0 (success) or 1 (failure)


sp_helpdistributiondb is used in all types of replication.


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.

See Also

View and Modify Distributor and Publisher Properties
sp_adddistributiondb (Transact-SQL)
sp_changedistributiondb (Transact-SQL)
sp_dropdistributiondb (Transact-SQL)
System Stored Procedures (Transact-SQL)