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