• From SSMS Object Explorer, you can also right clicks on a database and set the 'Restrict Access' propery from the default 'MULTI_USER' value 'RESTRICTED_USER', which will achieve the same result as the T-SQL command I mentioned above. If you choose to do this, then remember to set it back to 'MULTI_USER' when it's time for users to start re-connecting again.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho