Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 ???

Author  Topic 

page69
Starting Member

2 Posts

Posted - 2003-04-11 : 09:43:42
hello,

the replication monitor has been deleted and is not
been shown in EM sqlserver7.
there is a way to restore this back?
thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-04-11 : 15:16:30
Since no one has posted the answer, here is how you can find out how to do it:

Either search through the stored procedures in the master database to figure out which one you need to call.

OR

If you have a test server available, run SQL Profiler on it (trace your account), setup replication on the test server, stop the trace, then look the trace to determine what stored procedure it called to create the monitor.

OR

Generate the scripts to create replication by right clicking replication in EM and selecting Generate Script. Then check through the script to find out if the creation of the monitor is in there (don't know if it is though). If it is, then just run that part of the script only.

HTH,

Tara
Go to Top of Page

page69
Starting Member

2 Posts

Posted - 2003-04-15 : 08:39:12
thank you.

Go to Top of Page
   

- Advertisement -