Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to find uncommitted transactions in all Replications. Expand / Collapse
Author
Message
Posted Monday, July 29, 2013 3:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 6:43 AM
Points: 13, Visits: 111
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.
Post #1478492
Posted Monday, July 29, 2013 7:29 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 9:33 AM
Points: 414, Visits: 809
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
Post #1478582
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse