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