I run the EXECUTE sp_who2;
then found a BlkBy pid. I want to kill it then I run the command
begin transaction
kill 206
But the error is thrown.
KILL command cannot be used inside user transactions.
I run the EXECUTE sp_who2;
then found a BlkBy pid. I want to kill it then I run the command
begin transaction
kill 206
But the error is thrown.
KILL command cannot be used inside user transactions.
You cannot run KILL in a transaction - in cannot be rolled back so no need.
Thus just run KILL 206;
Remember the 206 changes.
Process ID 206 is not an active process ID.
The process seems to be in an application. But I already stopped the application.