title: How to disconnect all users in sql server except sa?
body: <p>I would like to disconnect all users from SQL Server except <code>sa</code>.</p>
  
  <p>The need for this is:</p>
  
  <p>I wrote a db maintenance utility for my ERP. Before running it I need to ask all users to logoff.
  So somehow I would like to give them a message (through ERP) "disconnecting in 5 minutes, please save your work and logoff or you'll be kicked out" and then after 5 minutes run the command on the server that disconnects all people.
  I want "sa" or anyway "1 specific user" not to be disconnected, since the db maintenance utilty will use that user for db connection.</p>
  
  <p>I found this:</p>
  
  <pre><code>use master
  alter database MyDatabase set offline with rollback immediate
  </code></pre>
  
  <p>but how to say "one specific user is an exception"?</p>