title: SQL Server tells me database is in use but it isn't
body: <p>SQL Server keeps telling me a database is in use when I try to drop it or restore it, but when I run this metadata query:</p>
  
  <pre><code>select * from sys.sysprocesses 
  where dbid 
    in (select database_id from sys.databases where name = 'NameOfDb')
  </code></pre>
  
  <p>It returns nothing.</p>
  
  <p>Sometimes it will return 1 process which is a CHECKPOINT_QUEUE waittype.  If I try to kill that process, it won't let me (cannot kill a non-user process).</p>
  
  <p>Anyone have any idea what's wrong?</p>