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

NUnit : Introduction

There are several unit test tools in the market, but one of them is NUnit, the most popular tool for doing unit testing. So in this tutorial...