SQLZOO, Find another process and kill it.

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.	USE master; SELECT spid , nt_username, datediff(s,login_time,GETDATE()) FROM sysprocesses; DECLARE @var1 int SELECT @var1 = spid FROM sysprocesses WHERE nt_username='andrew' AND spid<>@@spid EXEC ('kill '+@var1); SELECT spid , nt_username, datediff(s,login_time,GETDATE()) FROM sysprocesses;
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.

SQLzoo.net