Status of Replication through ASP.NET | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Status of Replication through ASP.NET

I need to know the current status of replication through ASP.NET component or class, 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. Usually this connection breaks and the replication fails. I need a ASP.NET component or class to track this. Both of the servers have win 2000 and Sql server standard addition. Please help me.
The status of replication will be logged to SQLAgent log and Snapshot agent, you may try from ASP.NET to capture this information from these text files. HTH Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>