July 14, 2009 at 10:12 am
Hello
What is the table or command I need to type (and where) to check for the number of transactions and the transaction related details are waiting to be processed by the "distributor agent"?
Regards
Sourav
Thanks.
July 14, 2009 at 10:16 am
Sourav Mukherjee (7/14/2009)
HelloWhat is the table or command I need to type (and where) to check for the number of transactions and the transaction related details are waiting to be processed by the "distributor agent"?
Regards
Sourav
Check out for sp_browsereplcmds in BOL.
July 14, 2009 at 10:22 am
When using transactional replication, transaction commands are stored in the distribution database until the Distribution Agent propagates them to all Subscribers or a Distribution Agent at the Subscriber pulls the changes. These pending commands in the distribution database can be viewed programmatically using replication stored procedures.
To view replicated commands from all transactional publications in the distribution database
At the Distributor on the distribution database, execute sp_browsereplcmds.
To view replicated commands in the distribution database from a specific article or from a specific database published using transactional replication
(Optional) At the Publisher on the publication database, execute sp_helparticle. Specify @publication and @article. Note the value of article id in the result set.
At the Distributor on the distribution database, execute
============== Thanks much =========================================
Regards
Sourav
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply