On SQLServerCentral.com tonight, I found a really neat little SQL procedure written by Brian Knight that allows you to disconnect any users currently connected to a specific database.
I needed this script so I could disconnect all of the CRM users so I could perform some maintenance on the CRM databases.
Loading ...
The following command will disconnect all users and make sure that users cannot logon while you are making your changes…
ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
You can allow access again with the MULTI_USER option
Excellent suggestion! Thanks Darrel.
How do you force[diconnect] all connected users from the database, I'm trying to delete a database and it gives me an error saying that there is a connected user and it is in a single_user state
ALTER DATABASE uasdb SET multi_USER WITH ROLLBACK IMMEDIATE