Transact-SQL Reference
MSdistributiondbs
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 | 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. |