February 6, 2009 at 5:46 am
Comments posted to this topic are about the item Database Sizes
Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
February 20, 2009 at 3:43 am
It would be nice to know the space used and the space available too...
March 16, 2009 at 1:18 am
A condition in a where clause should be :
insert into #spacetemp (DBname,DBcreationDate,DBStatusid,DBStatus)
select [name],crdate, status,case
when status=1 then 'autoclose'
(....)
end
from master..sysdatabases where (status & 512 = 0) and dbid >case when @sysdb=1 then 0 else 4 end
To prevent crash on a offline databases.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy