Sep 14, 2015

How to identify open transactions in SQL Server


There are many way to find open transaction which are not COMMIT or ROLBACK.

Below script may help you to find out open TRANSACTION in SQL Server
1.  Using  SYS.SYSPROCESSES 
SELECT * FROM SYS.SYSPROCESSES WHERE OPEN_TRAN = 1

2.  Using  SYS.DM_TRAN_SESSION_TRANSACTIONS
SELECT * FROM SYS.DM_TRAN_SESSION_TRANSACTIONS