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
Posted Friday, May 8, 2009 1:44 AM



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.


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
Post #1730348
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse