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

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



Group: General Forum Members
Last Login: Thursday, May 7, 2015 4:43 PM
Points: 469, Visits: 410
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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse