Using SQL Server 2005. Replication working fine except the distribution table is continuely growing. Started to configure maintenance job (catagory: REPL-Distribution Cleanup) Any suggested steps that will not break the replication. Is there a SP available that will address my problem.
Thanks,
You can reduce the retention period using sp_changedistributiondb.
For more info, please refer to the following articles.
http://msdn2.microsoft.com/fr-fr/library/ms146868.aspx
http://msdn2.microsoft.com/fr-fr/library/ms181877.aspx
Regards,
Gary
