In SQLServer 2005 one can change the user mode of a database to multi, single or restricted. MULTI_USER - This is the default mode, means multiple user can connect to the database. ALTER DATABASE <DB Name> SET MULTI_USER SINGLE_USER - In single user mode only one connection is allowed at at time to the database. … Continue reading Database user mode →