Set a Database to Single-user Mode

This topic describes how to set a user-defined database to single-user mode in SQL Server 2014 by using SQL Server Management Studio or Transact-SQL. ... Connect to the Database Engine. From the Standard bar, click New Query. Copy and paste the ...

msdn.microsoft.com