From: esquel@sommarskog.se   
      
   SUBBU N (nsubbu1986@gmail.com) writes:   
   > Hi...Am using sql2008R2 .i try to find out all db sizes through this   
   > query, but it is not shows any size of the databases.that result is it   
   > showas only all db size is 'o'and log file size also '0'.please verify   
   > and replay to me   
      
   Maybe all your databases are less than 1GB size? Rewrite the query to   
   show the size in megabytes.   
      
   When I tested it, I got 0 for most databases file, since I only have a   
   bunch of toy databases here at home. But I did see a couple of non-zero   
   values.   
      
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)