Database Sizes

  • Comments posted to this topic are about the item Database Sizes

    Vinay Kumar
    Keep Learning - Keep Growing !!!

  • It would be nice to know the space used and the space available too...

  • 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'



    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