Check / Kill MS SQL Transactions

1. DBCC opentran()
Above command return current opened transactions and you will get here "spid". i.e 63

2. exec sp_who2 63 
Above Command check Transaction status from spid

3. exec sp_lock 63
Check lock status from spid

4. kill 63 
This will close the transaction by spid

5. SELECT status,* FROM sys.sysprocesses where spid=63
This will show status of transaction