title: Cannot use KILL to kill your own process
body: <p>I have SQL Server database which I want to delete using</p>
  
  <pre><code>DROP DATABASE &lt;database-Name&gt;
  </code></pre>
  
  <p>But I receive this error:</p>
  
  <p>Cannot drop database "Database-Name" because it is currently in use.</p>
  
  <p>To solve the issue I called sp_who so I can see spid of the database which is in use.</p>
  
  <p>Then I tried to kill it using : </p>
  
  <pre><code>KILL &lt;spid&gt;
  </code></pre>
  
  <p>But I see this error: Cannot use KILL to kill your own process.
  I use SQL SERVER Management Studio to run the commands.</p>