Terminate

Table of Contents



Terminates a process: rolls back its transaction, disconnects it and frees its resources. Kill does the same thing.

Terminate(Numeric processId)

Permissions

Requires an account that is a member of an administrator role.


round-pushpin Terminates process 100.
EXEC Terminate(100)




SQL :: System Procedures
Built-in procedures for inspecting and managing the database engine.
SQL :: Transaction
Transactions make a group of statements all-or-nothing.