SELECT SQL Server SQL call?

Question

I have a cameraman SELECTwho hangs and I would like to kill him. I access the server using the SQL GUI if that matters (not Microsoft).

Is there a command I can execute to kill this process?

I get this when using EXEC('Kill ' + Pid):

The KILL command cannot be used inside user transactions.

Answer 1

You can try to execute the command KILL.

Answer 2

KILL , , KILL . , OFFLINE BACKONLINE. .

DEATTACH, "overkill", , .

, , !