Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Setting Single User Mode - SQL School Video Expand / Collapse
Author
Message
Posted Friday, June 26, 2009 4:57 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 8:09 AM
Points: 6,779, Visits: 1,862
Comments posted to this topic are about the item Setting Single User Mode - SQL School Video

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #743011
Posted Thursday, July 16, 2009 7:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 27, 2011 9:26 AM
Points: 2, Visits: 31
So is the single user the user setting the DB to single user mode? I've always wondered about single user mode, but have been using Restricted User which doesn't help me when trying to kick out users that are DB owners.
Post #754183
Posted Thursday, July 16, 2009 11:29 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 30, 2010 11:27 AM
Points: 435, Visits: 1,403
I find single user mode too restrictive, in that I cant open other SSMS queries, or run, e.g. SSIS jobs. What I really want (guess I am just selfish) is single login-in mode, where I can do anything I want under my user id, but all others are excluded.
My compromise is RESTRICTED_USER WITH ROLLBACK AFTER 10 SECONDS, but every now and then during my bi-weekly update I run afoul of others with admin privilages.
Is there a better way to lock out the DB for maintanance? Should I simply wrap my truncate-reload table processes as transactions?

(On another topic, I was unable to spell check this post, as every word (except "I"!) was marked as an error with no suggestions--missing dictionary??)
Post #754380
Posted Thursday, July 16, 2009 1:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 27, 2011 9:26 AM
Points: 2, Visits: 31
Agreed. Being able to set single user mode to a specific username would be awesome. I don't understand why that functionality isn't there.
Post #754454
Posted Thursday, July 16, 2009 1:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 16, 2009 1:42 PM
Points: 1, Visits: 0
how to separate db and add exit buttons to them?
Post #754466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse