Groups | Blog | Home
all groups > sql server replication > january 2007 >

sql server replication : Replication monitor


tdziemidowicz NO[at]SPAM gmail.com
1/10/2007 6:44:52 AM
Is there anyway to clear replication monitor from subscriptions with
error status?

Tomek
Paul Ibison
1/10/2007 3:00:30 PM
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 .

AddThis Social Bookmark Button