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


Posted in: The Best of MSDN Blogs  Tags:
blog comments powered by Disqus

by Lee Everest, M.S.

Poll

Do you use Azure or cloud in your organization?
Show Results

Ads

Search


Month List

Calendar

«  February 2012  »
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog