I always like little tips and tricks when I see one from someone who picked it up out in the trenches, at a client location, rather than one in the lab. Here’s one from the MSDN folks; check this out and keep this in your toolbox in case someone gets a database put into single-user mode, and the activity on the server doesn’t allow the ALTER DATABASE command to be run to get it to multi user.
Thanks for the tip!
Lee Everest
--------------------------
http://blogs.msdn.com/b/dfurman/archive/2012/01/20/getting-out-of-single-user-mode.aspx
51a6bac9-6d01-4c6b-ba1d-831f55de2860|0|.0