Solved

running SINGLE_USER from master database- does it include you?

Posted on 2009-07-01
4
174 Views
Last Modified: 2012-05-07
When we run SINGLE_USER command for a database from the master database, does it give the chance for another process to connect and become the single user connected?

I guess when you run that from that database itself, it will assume that you are the only user.

The purpose to do this is to do a restore of the database(so all the users are gone). that is why I am thinking of running it from the master DB; but wondering if anyone else will be able to connect before the restore begins.

Thanks.
0
Comment
Question by:anushahanna
  • 3
4 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 470 total points
ID: 24753328
Hi anushahanna,

Have a look at the following:
http://www.dev30.com/?tag=/single_user

Good Luck!

Gary
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24753355
0
 
LVL 6

Author Comment

by:anushahanna
ID: 24753429
tbsgadi,
It does not tell specifically in the articles, but I assume, that even when you run the command from master DB, it considers you as the only user, and thus killing all other connections?

Thanks
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24753445
Exactly
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now