The SQL Server gets restarted nightly and this problem still occurs. I cannot restart SQL in the middle of the day, because it is a production server.
When I run sp_MSload_replication_status, there is no effect. Any other ideas??
Larry...
-----Original Message----- Larry, it doesn't matter which database you run this from. If it doesn't work, try restarting the sql server agent. HTH, Paul Ibison http://www.nwsu.com/0974973602p.html) .
Larry, these rogue red x's should be removed when restarting the server, so I'd just wait till the reboot - after all they aren't actually a problem. BTW I'm asuming that they are rogue icons - ie the error isn't registered correctly in one of the agents. Rgds, Paul Ibison
(recommended sql server 2000 replication book: http://www.nwsu.com/0974973602p.html)
can you query the msrepl_errors table in the distribution database to get an idea of any possible errors that might have occured.
select * from msrepl_errors where error_type_id is not null -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html
Post by Paul Ibison Larry, these rogue red x's should be removed when restarting the server, so I'd just wait till the reboot - after all they aren't actually a problem. BTW I'm asuming that they are rogue icons - ie the error isn't registered correctly in one of the agents. Rgds, Paul Ibison http://www.nwsu.com/0974973602p.html)