December 24, 2009 at 3:21 pm
How can i find list of databases in single user mode and its size.
December 24, 2009 at 4:29 pm
select name from master.sys.databases where user_access_desc='SINGLE_USER'
December 25, 2009 at 2:36 pm
Great! You figured it out yourself AND posted the valuable feedback.
Happy holidays
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply