More info needed than given by DBCC OPENTRAN

[antzzz]

When I came on a Monday morning, I found out that there was open transaction running since Friday afternoon by using DBCC OPENTRAN.

Is there a way to know what SQL Statement is actually not being committed?

Is there any utility that I can use to "read" the transaction log?

Any help is appreciated!

Thanks

 

[tran008]

these are the log reader tools out there:

* Log Explorer (Lumigent)

http://www.lumigent.com/products/le_sql.html

* Log P.I. (Coherent Software Corp)

http://www.logpi.com/

* ApexSQL Log (ApexSQL Software

http://www.apexsql.com/

is there any spid that still running?