We need to do a restore, and cannot because other users are connected. We thought we had disconnected every process, but apparently not.
How can we, from Management Studio, kick off everyone else so we can do this backup?
There are two ways of doing it:
1) Right click on the database in Object Explorer go to Tasks > Detach. Select the Drop Connections checkbox.
2) Set the database to single-user mode as outlined here:
I use this code:
But I can see the SINGLE USER example is less to type.