sp_helpdistributiondb (Transact-SQL)
Returns properties of the specified distribution database. This stored procedure is executed at the Distributor on the distribution database.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
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 associated with the Distributor and on which the user has permissions.
Return Code Values
0 (success) or 1 (failure)
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. |
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.
See Also
Reference
sp_adddistributiondb (Transact-SQL)
sp_changedistributiondb (Transact-SQL)
sp_dropdistributiondb (Transact-SQL)
System Stored Procedures (Transact-SQL)
Other Resources
How to: View and Modify Publisher and Distributor Properties (Replication Transact-SQL Programming)