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??)