SQLTeam.com | Weblogs | Forums

KILL command cannot be used inside user transactions


#1

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.


#2

You cannot run KILL in a transaction - in cannot be rolled back so no need.
Thus just run KILL 206;
Remember the 206 changes.


#3

Process ID 206 is not an active process ID.

The process seems to be in an application. But I already stopped the application.