Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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.