Snapshot Publication is not allowing cleanup of the distribution database
in setup have both transactional publications , snapshot publications. understanding snapshot publication not track or care transactions occured since last sync. every execution of sync deliver existing snapshot, snapshotting operation takes data out of tables. problem code in sp_msmaximum_cleanup_seqno considers last transaction delivered each of distribution agents found in msdistribution_agents. includes distribution agent delivers snapshot. therefore, distribution database accumulates transactions between executions of snapshot+sync operations. see it, have missed configuration option. otherwise, seems option modify sp_msmaximum_cleanup_seqno or similar circumvention of tracking occurs. suggestions solutions? even though snapshot agent shut down, log reader agent continues delivering transactions distribution database. these transactions delivered subscribers distribution agents running transactional publications. problem not snapshot agent itself, or snapshot replication...