dbcc opentran

How do I do anything with the results of this guy? How do I find out what
these LSN's are doing?
Replicated Transaction Information:
Oldest distributed LSN : (574262:1479:4)
Oldest non-distributed LSN : (574262:1498:1)
--
SQL2K SP3
TIA, ChrisRI think it means, that you have transactional replication setup in this
database. And the logreader agent has not yet picked up that transaction.
Make sure your log reader agent for this published database is running. If
it isn't running or failed, then you have to start it and fix any errors it
is encountering. Once log reader picks up all the replicable transactions,
there won't be any replication open transactions.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"ChrisR" <bla@.noemail.com> wrote in message
news:%23ODpR8R5EHA.3124@.TK2MSFTNGP11.phx.gbl...
> How do I do anything with the results of this guy? How do I find out what
> these LSN's are doing?
> Replicated Transaction Information:
> Oldest distributed LSN : (574262:1479:4)
> Oldest non-distributed LSN : (574262:1498:1)
> --
> SQL2K SP3
> TIA, ChrisR
>