MSdistributiondbs (T-SQL)

Contains one row for each distribution database defined on the local Distributor. This table is stored in the replicated 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.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.