Eine Einführung in

SQL

Find another process and kill it.

MS SQL Server

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 MS 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.