How to identify open transactions in SQL Server

There are many ways to find open transaction which is not COMMIT or ROLLBACK.

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