Thank you for your question. You can check active transaction in a database by the following SQL Statement that syntax is.
DBCC OPENTRAN
[
( [ database_name | database_id | 0 ] ) ]
{ [ WITH TABLERESULTS ]
[ , [ NO_INFOMSGS ] ]
}
]
You will get SPID (server process ID). Then use Kill to terminate it.
KILL { session ID | UOW } [ WITH STATUSONLY ]
Thanks,
Mamun