SQL Server Performance Forum – Threads Archive
Status of Replication through ASP.NETI 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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.