Thursday, March 22, 2012

Database size

Hi!
Is it possible to ask a database (using a SQL statement) how big it is?
Regards
/AndersHi
Yes, It is
sp_helpdb 'databasename'
"Anders Wåhlin" <anders.wahlin@.erv.ericsson.se> wrote in message
news:bnoeat$k7k$1@.newstree.wise.edt.ericsson.se...
> Hi!
> Is it possible to ask a database (using a SQL statement) how big it is?
> Regards
> /Anders
>|||sp_spaceused will display size of current database,
optionally you can also pass an argument to this procedure
<tablename> to know size of a particular table.
>--Original Message--
>Hi!
>Is it possible to ask a database (using a SQL statement)
how big it is?
>Regards
>/Anders
>
>.
>

No comments:

Post a Comment