title: Rollback trans and unlock tables on SQL Server
body: <p>Hy , sometimes I had problems with <code>SQL Server</code> because of unknown transactions left opened or a lock table, and I read many suggestion to avoid restarting the server<br>
  until I found this , and it seems to work<br>
  do you have others suggestion to release locks and rollback trans ?<br>
  because I am reserved on running this on a production server</p>
  
  <pre><code>USE master;
  GO
  ALTER DATABASE [db_dev]
  SET SINGLE_USER
  WITH ROLLBACK IMMEDIATE;
  ALTER DATABASE [db_dev]
  SET MULTI_USER;
  GO
  </code></pre>