• [edit]: Realized after just posting this that this is the SQL 7,2000 forum - the queries below run in my SQL 2008 environemnt and I don't know if they will work in 7 or 2000.

    What kind of replication do you have setup? Transactional or snapshot or merge or P2P?

    Assuming this is transactional replication:

    Are you seeing the "No replicated transactions are available" for the log reader agent or the distribution agent?

    Run the following queries in your distribution server in the context of the distribution DB to check on what is happening in the log reader and distributor agents:

    -- check on the comments, delivered_transactions, delivered_commands,

    -- average_commands, delivery_rate and delivery_latency over time to see how the

    -- log reader agent is processing data

    sp_MSenum_logreader @name = '%',@show_distdb =0

    GO

    -- check on the comments, delivered_transactions, delivered_commands, delivery_rate and

    -- delivery_latency columns over time to see how the distribution agent is processing data

    sp_MSenum_distribution @name = '%',@show_distdb =0

    GO

    Are there any errors in replication monitor or in the distributor/log reader jobs?