title: SQL deadlocking..in single user mode now
body: <p>Couple of databases produced an error this morning whilst running in Single User Mode.  Due to the following error I am unable to do anything :(</p>
  
  <pre><code>Msg 1205, Level 13, State 68, Line 1
  Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
  </code></pre>
  
  <p>I receive that error when trying the following (using the Master Database as a Sys Admin):</p>
  
  <pre><code>ALTER DATABASE dbname
  SET MULTI_USER;
  GO 
  </code></pre>
  
  <p>For the sake of it I have tried Restarting the SQL Server, I have tried killing any processes and I have even tried resetting the single user myself:</p>
  
  <pre><code>ALTER DATABASE dbname
  SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
  GO
  </code></pre>
  
  <p>The job which was running was designed to copy the database and put it in single user mode immediately to try and make it faster.</p>
  
  <p>Anyway I can remove the locks?</p>