December 19, 2006 at 9:16 am
I have my replication distributor set up on a sql 2000 sp 4 on Windows 2000 sp4 (separate from publisher and subscriber dbs). I am having an issue where the status for the log reader or distribution agent in replication monitor looks like it is still running but when you look at the active transactions (sp_who2 active) on the publisher and subscriber there are no active transactions for the log reader or distribution agent to pick up.
It seems to have started when sp4 was applied (we were able to see the correct status at one point). Has anyone else had this issue? I can't find anything on the KB about it.
Thanks in advance!
December 19, 2006 at 5:23 pm
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
December 20, 2006 at 8:20 am
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 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply