I ran dbcc opentran after running this query.

I receive a no active open transactions message. If the transaction is still open why did I get this message?

We are considering setting up a Transactional Replication and have some questions you could possible help us with.

When continuously, how often does the log reader agent update? ...