Setting Single User Mode - SQL School Video

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Andy Warren » Setting Single User Mode - SQL School Video

Setting Single User Mode - SQL School Video

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Warren

Posted Friday, June 26, 2009 4:57 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Comments posted to this topic are about the item Setting Single User Mode - SQL School Video

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #743011

jmajcen

Posted Thursday, July 16, 2009 7:47 AM

Forum 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

Jim Russell-390299

Posted Thursday, July 16, 2009 11:29 AM

SSC-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

jmajcen

Posted Thursday, July 16, 2009 1:24 PM

Forum 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

jbeauch787

Posted Thursday, July 16, 2009 1:44 PM

Forum 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 »

Permissions