replication monitor icon become red color

Hi guys,
I just re-create replication and everything seems like ok. I can replicate
data into subscriber. Only on the replication monitor icon, it has red cross
icon. under it, in the treeview, each item has red color with cross icon. I
check the history, no error, and data has been transfer successfully. Can
some one tell me how to get rid of it? Thanks.
the replication is working fine, only replication monitor become red. The
agent is ok, no error in the history. I don't know why it is red cross on it.
"Iter" wrote:

> Hi guys,
> I just re-create replication and everything seems like ok. I can replicate
> data into subscriber. Only on the replication monitor icon, it has red cross
> icon. under it, in the treeview, each item has red color with cross icon. I
> check the history, no error, and data has been transfer successfully. Can
> some one tell me how to get rid of it? Thanks.
>
|||The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and running
sp_MSload_replication_status refreshes this table. As restarting the SQL
Server Service causes the tempdb to be recreated from the model database,
this also removes the problem.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .