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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-20 : 08:17:02
|
| saleem writes "I need to know the current status of replication through query, i.e. to check wether the replication is running or has stopped due to some error, the service may stop due to non availability of connection between the two servers, this may happen because of network break down or internet service interruption. The two servers are placed at different geographical locations and connected through internet connection. Usually this connection breaks and the replication fails. I need a sql query to track this. Whenever the connection fails I can generate an alert so I need the sql query or system stored procedure which tells me that replication has stopped.Both of the servers have win 2000 and Sql server standard addition." |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-02-20 : 10:57:13
|
| Take a look at the replication monitor through EM. You can drill down into the agent(s) you want to monitor and set notifications just like any job (email, page, net setnd, app log). |
 |
|
|
|
|
|
Replication status query