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, September 13, 2016 6:57 AM
Points: 487, Visits: 447
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 4:20 AM
Points: 329, Visits: 672
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