Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

running SINGLE_USER from master database- does it include you?

Posted on 2009-07-01
4
176 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

809 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