Groups > comp.databases.ms-sqlserver > #1491

Re: Hi Experts i have doubt

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Hi Experts i have doubt
Date	2013-05-27 23:24 +0200
Organization	Erland Sommarskog
Message-ID	<XnsA1CDEE14D53E3Yazorman@127.0.0.1> (permalink)
References	<ab1bae77-157c-4440-b342-230649e1e8d3@googlegroups.com> <d7e8a0b2-7ea8-43b8-ac07-78a92e38c923@googlegroups.com>

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Hi Experts i have doubt n <nsubbu1986@gmail.com> - 2013-05-21 06:27 -0700
  Re: Hi Experts i have doubt rja.carnegie@gmail.com - 2013-05-21 07:16 -0700
    Re: Hi Experts i have doubt Erland Sommarskog <esquel@sommarskog.se> - 2013-05-21 21:22 +0200
  Re: Hi Experts i have doubt SUBBU N <nsubbu1986@gmail.com> - 2013-05-27 00:44 -0700
    Re: Hi Experts i have doubt Erland Sommarskog <esquel@sommarskog.se> - 2013-05-27 23:24 +0200
      Re: Hi Experts i have doubt rja.carnegie@gmail.com - 2013-05-27 19:02 -0700
        Re: Hi Experts i have doubt Erland Sommarskog <esquel@sommarskog.se> - 2013-05-28 08:29 +0200

csiph-web