Post reply

Replication - Pending Transactions

  • January 9, 2008 at 3:25 am

    #182655

    Hi,

    Can any one help me out on how to find out the Pending transactions for Subscriber in a Replication environment.

    The problem is my replication is taking huge time to drain the transactions. I need to check how many and what transactions are there in pending tray.

    Do SQL Server 2005 maintains any table where we can get the pending transactions to be applied in subscriber.

  • January 12, 2008 at 6:08 pm

    #767445

    view the "Uncommitted Command" tab in Replication Monitor, it will show was is pending and estimated time for delivering these updates to subscriber.

  • January 14, 2008 at 12:27 am

    #767570

    Hi,

    Thanks for your response. In that tab we can see the no. of undistributed commands. I need the exact Sql Syntax / statement / procedure which are pending or in queue for replication.

  • January 14, 2008 at 1:30 am

    #767583

    Check out the following script. You can use the SQL statment used in the script.

    http://www.intellipool.se/forum/index.php?showtopic=1133

    Regds,

    R@j

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply