MSdistributiondbs (Transact-SQL)
The MSdistributiondbs table contains one row for each distribution database defined on the local Distributor. This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
name |
sysname |
The name of the distribution database. |
min_distretention |
int |
The minimum retention period, in hours, before transactions are deleted. |
max_distretention |
int |
The maximum retention period, in hours, before transactions are deleted. |
history_retention |
int |
The number of hours to retain history. |
See Also
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables