sp_helpdistributiondb

Transact-SQL Reference

Transact-SQL Reference

sp_helpdistributiondb

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

Syntax

sp_helpdistributiondb [ [ @database = ] 'database_name' ]

Arguments

[@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.
Remarks

sp_helpdistributiondb is used in all types of replication.

Permissions

Execute permissions default to the public role.

See Also

sp_adddistributiondb

sp_changedistributiondb

sp_dropdistributiondb

System Stored Procedures