Database Size

Hello there
Is there a way to get the data file size and log file size with code?sp_helpdb dbname
HTH. Ryan
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23CMY$leEGHA.2040@.TK2MSFTNGP14.phx.gbl...
> Hello there
> Is there a way to get the data file size and log file size with code?
>|||sp_helpdb <db>
"Roy Goldhammer" wrote:

> Hello there
> Is there a way to get the data file size and log file size with code?
>
>|||Roy
select * from sysfiles
or
select * from master..sysaltfiles where dbid =yourdbidhere
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23CMY$leEGHA.2040@.TK2MSFTNGP14.phx.gbl...
> Hello there
> Is there a way to get the data file size and log file size with code?
>