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