sp_helpdistributiondb (Transact-SQL)

Applies to: SQL Server Azure SQL Managed Instance

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

Transact-SQL syntax conventions

Syntax

sp_helpdistributiondb [ [ @database = ] N'database' ]
[ ; ]

Arguments

[ @database = ] N'database'

The database name for which properties are returned. @database is sysname, with a default of % for all databases associated with the Distributor, and on which the user has permissions.

Result set

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).

Remarks

sp_helpdistributiondb is used in all types of replication.

Permissions

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.