Sometimes users set off queries that may take a very long time to complete.
We may want to find such long running processes and stop them. Some kind of administrative account is usually required.
|Specific to SQL Server|
|sysprocesses in the master database includes all the SQL statements that are currently running. @@spid is your process. @var1 is a local variable.|