TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

MSdistributiondbs (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 nameData typeDescription
namesysnameThe name of the distribution database.
min_distretentionintThe minimum retention period, in hours, before transactions are deleted.
max_distretentionintThe maximum retention period, in hours, before transactions are deleted.
history_retentionintThe number of hours to retain history.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft