sql server – How to kill a stored procedure that is in an open transaction?

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

The result will show everything that is running at this time, you can identify your stored procedure in execution.

then run: kill [session_id from the previous query]
The transaction will be reversed.