sys.sp_changedistributiondb

general
#stored-procedure

Description

Changes the properties of the distribution database. This stored procedure is executed at the The name of the distribution database. The property to change for the given database. History table retention period. Maximum distribution retention period. Minimum distribution retention period.

Syntax

sp_changedistributiondb
[ @database = ]
N
'database'
[ , [ @property = ]
N
'property'
]
[ , [ @value = ]
N
'value'
]
[ ; ]