Log reader/distribution agent status not correct in monitor

  • I don't think you see active spid when there are no trasactions to replication...

    Do you any errors?

    sp_who2 active gives you active spids info...

     

    MohammedU
    Microsoft SQL Server MVP

  • I would expect if the log reader or distribution agent were idle (e.g., no active transactions) that the status would be idle.  Instead I see running tranactions if I use sp_who2 active.  Is that not the case?

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply