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
 SQL Server Administration (2008)
 Replication - How to check Undistributed Commands

Author  Topic 

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2011-06-14 : 09:29:10
Hi all,

In transactional replication, is there any way I can check the number of undistributed commands waiting to be applied to the subscriber? Apart from using replication monitor.

Is there a stored procedure or table that I can query?

I need to store this information every 30s, hence replication monitor is out of the question.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-06-14 : 10:33:44
Execute sp_replmonitorsubscriptionpendingcmds at the distributor.
Go to Top of Page
   

- Advertisement -