sql server 查询db事务没有提交的情况

select *
from sys.dm_tran_session_transactions 
where is_user_transaction=1 


select * from sys.dm_exec_connections c 
cross apply sys.dm_exec_sql_text(c.most_recent_sql_Handle) s 
where session_id=158