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

Re: Hi Experts i have doubt

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!mx05.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Hi Experts i have doubt
Date	Mon, 27 May 2013 23:24:15 +0200
Organization	Erland Sommarskog
Lines	16
Message-ID	<XnsA1CDEE14D53E3Yazorman@127.0.0.1> (permalink)
References	<ab1bae77-157c-4440-b342-230649e1e8d3@googlegroups.com> <d7e8a0b2-7ea8-43b8-ac07-78a92e38c923@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx05.eternal-september.org; posting-host="78e2ae7e6764121e217a035f19bdb315"; logging-data="20321"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+8vKNpi4MimnkD3+A8hK2L"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:V1x6ZHiIpzsqtZUUx9uVqapgnqc=
Xref	csiph.com comp.databases.ms-sqlserver:1491

Show key headers only | 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