End an ALTER DATABASE immediately if anyone is in the database.

(Kenneth Fisher) The development team has told me they’ve shut down the application, there are no more connections and I can go ahead and set the database to SINGLE_USER, or maybe RESTRICTED_USER before running various processes on it. I check and low and behold, no connections.

Register to Read