Distribution Agent Issue

I have Transactional Replication set up in unidirection where subscribers are
getting read only data. Articles dont have any horizontal and vertical
partitioning either. The problem is even though there are transactions taking
place in Publisher, distribution agent is sitting idle and not replicating
any transactions. It is not throwing any errors either. Distribution agent is
just sitting idle and not replicating any data at all. This is really
strange. Any thoughts by anyone?
More information:
SQL 2000 EE SP3a on Windows 2003.
"Mark" wrote:

> I have Transactional Replication set up in unidirection where subscribers are
> getting read only data. Articles dont have any horizontal and vertical
> partitioning either. The problem is even though there are transactions taking
> place in Publisher, distribution agent is sitting idle and not replicating
> any transactions. It is not throwing any errors either. Distribution agent is
> just sitting idle and not replicating any data at all. This is really
> strange. Any thoughts by anyone?
>
|||Mark,
check to see if the job owner is a domain user, and if so please change to
sa.
Also check to see that the log reader agent has started and that
sp_browsereplcmds returns some rows.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul:
Job owner is distributor_admin. Should I still change the owner to sa? And
yes, sp_browsereplcmds is returning data so I am not sure why distribution
agent is not pushing data.
I have second scenario where on another server Log Reader shows the status
as running but it doesnt read any transactions from the publisher's
transaction log. Any comments on this one?
Thanks in advance.
"Paul Ibison" wrote:

> Mark,
> check to see if the job owner is a domain user, and if so please change to
> sa.
> Also check to see that the log reader agent has started and that
> sp_browsereplcmds returns some rows.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Mark,
try changing the job owner to sa and restarting the job. Am not sure about
the other one at all unless the commands are part of a long-running
transaction?
Rgds,
Paul Ibison