snipt

Ctrl+h for KB shortcuts

SQL

Kill Connections to a SQL Server DB

1
2
3
4
5
6
7
8
-- set your current connection to use master otherwise you might get an error

use master
ALTER DATABASE YourDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE 

--do you stuff here 

ALTER DATABASE YourDatabase SET MULTI_USER
https://snipt.net/embed/297fa3ad75d372205f12afbc7d24a12f/
/raw/297fa3ad75d372205f12afbc7d24a12f/
297fa3ad75d372205f12afbc7d24a12f
sql
SQL
8
2019-06-12T09:11:09
True
False
False
/api/public/snipt/129736/
kill-connections-to-a-sql-server-db
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a> <a href="#L-6">6</a> <a href="#L-7">7</a> <a href="#L-8">8</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="c1">-- set your current connection to use master otherwise you might get an error</span> </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a><span class="n">use</span> <span class="n">master</span> </span><span id="L-4"><a name="L-4"></a><span class="k">ALTER</span> <span class="k">DATABASE</span> <span class="n">YourDatabase</span> <span class="k">SET</span> <span class="n">SINGLE_USER</span> <span class="k">WITH</span> <span class="k">ROLLBACK</span> <span class="k">IMMEDIATE</span> </span><span id="L-5"><a name="L-5"></a> </span><span id="L-6"><a name="L-6"></a><span class="c1">--do you stuff here </span> </span><span id="L-7"><a name="L-7"></a> </span><span id="L-8"><a name="L-8"></a><span class="k">ALTER</span> <span class="k">DATABASE</span> <span class="n">YourDatabase</span> <span class="k">SET</span> <span class="n">MULTI_USER</span> </span></pre></div> </td></tr></table>
"SQL Server", T-SQL