is sp_replcounters accurate ?

How does sp_replcounters keep itself updated ? I cant seem to get it
refreshing. The replicated transactions for a database is around 8 and is
not decreasing althought the log reader agent is running.
Do you use it for accurate info to track any issues between the publisher
and the distribution database ?
It is somewhat accurate if your agents are running continuously. It uses an
extended stored procedure, so its hidden as to how it actually works.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uvRnZNdWFHA.2692@.TK2MSFTNGP15.phx.gbl...
> How does sp_replcounters keep itself updated ? I cant seem to get it
> refreshing. The replicated transactions for a database is around 8 and is
> not decreasing althought the log reader agent is running.
> Do you use it for accurate info to track any issues between the publisher
> and the distribution database ?
>