SQL SERVER – Change Database Access to Single User Mode Using SSMS

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Sun, 21 Nov 2010 01:30:21 +0000 Indexed on 2010/12/06 16:57 UTC
Read the original article Hit count: 773

I have previously written about how using T-SQL Script we can convert the database access to single user mode before backup.

I was recently asked if the same can be done using SQL Server Management Studio.

Yes!

You can do it from database property (Write click on database and select database property) and follow image.

Reference: Pinal Dave (http://blog.SQLAuthority.com)


Filed under: Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology

© SQL Authority or respective owner

Related posts about Pinal Dave

Related posts about sql