SQL Server – How to kill a stored procedure that is in open transaction?

Download SP_WhoisActive from here: http://whoisactive.com/
run it with this query: SP_who is active

the result will show everything that is running at the moment, you will be able to identify your stored procedure being executed.

then execute: kill [request_id of the query above]
the transaction will be canceled.