Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Open Transactions Expand / Collapse
Author
Message
Posted Friday, May 8, 2009 1:44 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, December 15, 2015 3:39 AM
Points: 479, Visits: 420
Hi All,

I know how to see active open transaction or current long running transaction (DBCC OPENTRAN) but how can I get the information of the long running transaction which has been occcured yesterday. I know I can see through background trace files but apart from this any other fast way to see this.

Thanks in advance.

Regards,
Austin

Post #712684
Posted Friday, October 23, 2015 7:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:53 PM
Points: 261, Visits: 501
may this help you http://www.sqlservercentral.com/Forums/Topic619606-360-1.aspx
Post #1730348
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse