Killing active tractions:
Before we kill active transactions we need to check what are all the open transactions running in our data base.
steps:
1.Choose data base name
2.execute DBCC OPENTRAN()
3.It shows open transactions with SID
4.Note down SID value like 54..
5.Run KILL 54
Wait for a time then check it.
