SQLServerCentral / Article Discussions / Discuss content posted by vinaykumar / Article Discussions by Author / Database Sizes / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 09:27:56 GMT20RE: Database Sizeshttp://www.sqlservercentral.com/Forums/Topic651532-576-1.aspxA condition in a where clause should be :insert into #spacetemp (DBname,DBcreationDate,DBStatusid,DBStatus) select [name],crdate, status,case when status=1 then 'autoclose'(....)endfrom master..sysdatabases where [b](status & 512 = 0)[/b] and dbid &gt;case when @sysdb=1 then 0 else 4 endTo prevent crash on a offline databases.Mon, 16 Mar 2009 01:18:04 GMTYenidaiRE: Database Sizeshttp://www.sqlservercentral.com/Forums/Topic651532-576-1.aspxIt would be nice to know the space used and the space available too...Fri, 20 Feb 2009 03:43:10 GMTJosepDatabase Sizeshttp://www.sqlservercentral.com/Forums/Topic651532-576-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/database+size/65752/">Database Sizes</A>[/B]Fri, 06 Feb 2009 05:46:34 GMTDanny Ocean