How to find uncommitted transactions in all Replications.

• katukuri.sqldba

  Mr or Mrs. 500

  Points: 531

  More actions

  July 29, 2013 at 3:15 am

  #277952

  Hi, How to find the uncommitted transactions in Replication. We have replication monitor, but other than that, do we have any ways to check and find them. Thanks.

• RTaylor2208

  SSChampion

  Points: 13298

  More actions

  July 29, 2013 at 7:29 am

  #1636632

  This is one method, it will at the very least give you a basis to create your own code should it give you exactly the result set you are looking for:

  http://www.sqlwebpedia.com/content/sql-replication-undelivered-command-count

  MCITP SQL 2005, MCSA SQL 2012