[quoted text, click to view] >-----Original Message-----
>sql2k sp3
>
>Im trying to truncate a tlog on a replicated db. It wont
>let me untill the results of dbcc opentran are empty. Im
>the only one on this test box and can verify that all
data
>has made it to the subscriber. But still, even after 20
>minutes of waiting, I run dbcc opentran and its not
empty.
>So my question is, how long after my last transaction is
>committed will dbcc opentran be empty? Is there a way to
>speed this up?
>
>TIA, Chris
>
>.