Sunday, February 19, 2012

I need away to show the pending transaction from transaction replication in a user friendly form

I want to list out the pending transaction for transaction replication by publication.

Help needed.

Are you looking for the pending trasactions in the transaction log or on the distributor? If it's the later, you can use sp_browsereplcmds to retrieve pending transactions.

http://msdn2.microsoft.com/en-us/library/ms176109.aspx

Thanks,

Dennis

No comments:

Post a Comment