Dynamic Management Views (DMV) to the rescue!

Look up in BOL sys.dm_tran_*. You'll find more information than you can shake a stick at. You can combine this with other DMVs like sys.dm_exec_requests or sys.dm_exec_sql_text or sys.dm_exec_query_plan, to put together just about any information you might want about ongoing transactions.