--1.查找未提交事务SELECT
session_id,
transaction_id,
is_user_transaction,
is_local
FROM
sys.dm_tran_session_transactions
WHERE
is_user_transaction =1;--2.根据返回的ID查询详细信息SELECT*FROM
sys.dm_exec_connections c CROSSapply sys.dm_exec_sql_text ( c.most_recent_sql_Handle ) s
WHERE
session_id =63;