title: How to kill/Terminate all running process on Sql Server 2008
body: <p>After executing this query on master db ,it is giving me all running process on all databases,
  is there any query which will kill all process running on a database .</p>
  
  <pre><code>USE
  Master
  GO
  
  SELECT
  SPID,DBID FROM SYSPROCESSES
  WHERE
  DBID NOT IN (1,2,3,4) AND SPID &gt;50 AND SPID&lt;&gt; @@spid   
  </code></pre>