KILL

Terminate a user process

Syntax
      KILL {session_ID | UOW} [WITH STATUSONLY] 

Key
   session_ID    The session ID of the process to terminate.Int)
   UOW           The Unit of Work ID of a  distributed transaction. (GUID)
   STATUSONLY    Generate a rollback progress report (for an earlier KILL statement)

The KILL statement may take some time to roll back a long transaction.

KILL WITH STATUSONLY will not terminate or roll back any transactions.

Example

KILL 54;
KILL 54 WITH STATUSONLY;
GO

"Whom the gods love dies young" - Menander 300 BC

Related commands:

sys.dm_tran_locks

Equivalent Oracle command:

ALTER SYSTEM KILL SESSION