Hello Master Gail: Thanks a million for such beautiful article on log behavior.

Quick Question: I have seen a situation where the there is no replication setup on the DB . CDC is wnabled. and the log_reuse_wait_desc shows as 'Replication'..

As per the article, undistributed transaction is causing the Log Growth. how can i check if which undistributed LSN ((43831:51:1) in my case) provided in DBCC OPENTRAN output is pointing to DDL operations of type ALTER TABLE.

how can i relate and compare the LSN in OPENTRAN with DDL Operation

Please have your comments on this..