====== Close Connections ======
  * Code below quickly closes all connections to database.

<code sql>
use master
ALTER DATABASE DBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE 

-- your code 

ALTER DATABASE DBname SET MULTI_USER
</code>