Cancel

Table of Contents

Overview
Prototype

Example

See also
Related

Cancels (rolls back) the transaction of the given process, leaving the process connected.

Cancel(Numeric processId)

Permissions

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

Cancels the transaction of process 100.

EXEC Cancel(100)

SQL :: Terminate

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

SQL :: Transaction

Transactions make a group of statements all-or-nothing.