[Description] The @retention property of sp_addpublication has been deprecated. Subscriptions are still marked as inactive and must be reinitialized if they have not synchronized within the maximum distribution retention period (the @max_distretention property of sp_adddistributiondb. For more information about retention periods, see Subscription Expiration and Deactivation. [Feature] 
Subscription expiration for transactional publications