Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayMSdistributiondbs (Transact-SQL)
Applies to: 
SQL Server
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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)