sql server replication: Why would a replication Push go into a status of "Running" and Last =
Action "Delivering Replicated Transactions", and yet just seem to be =
hung up there & not finishing.
This publication/subscription was running fine for months & now all of a =
sudden seems to be hanging.
The Log reader says X transactions with X commands were delivered, but =
when I look at the replicated db the rows are not present yet.

Sql 2000 - Trans. Rep.

Any Push in the right direction would be greatly appreciated.
thanx!

--=20

There could be some large transactions being applied. Run profiler to =
determine what they might be. You can also look in sp_browsereplcmds to =
see what is in the queue.

--=20
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

[quoted text, click to view]
Why would a replication Push go into a status of "Running" and Last =
Action "Delivering Replicated Transactions", and yet just seem to be =
hung up there & not finishing.
This publication/subscription was running fine for months & now all of =
a sudden seems to be hanging.
The Log reader says X transactions with X commands were delivered, but =
when I look at the replicated db the rows are not present yet.

Sql 2000 - Trans. Rep.

Any Push in the right direction would be greatly appreciated.
thanx!

--=20