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 2008 Forums
 Replication (2008)
 Replication Status

Author  Topic 

kokate_ajay
Starting Member

1 Post

Posted - 2010-02-03 : 08:16:07
I am having two server ServarA and ServerB, both the servers have sql server 2k, and Database MyDB is replicated by making ServerB as destributor and serverA as subscriber, replication type is Merge. whenever i have to check the status of replication i have to through Enterprise Manager only, but i have to develop one utility which shows the replication status.
but i am not able find such store procedure or function which gives the replication status...

Problem Statement : Is there any stored procedure which gives the SQL server replication status?.


Please help me me to find the solution..

zip12u
Starting Member

3 Posts

Posted - 2010-02-17 : 15:28:23
sp_distcounters

a
Go to Top of Page
   

- Advertisement -