SQL Datasizes

[MikeSchall]

I am looking for a way to find database file sizes. I would like to know Data and Log File Sizes, actual used space(data, index, and log). I would also like them in the same unit. Bytes would be nice, but at most KB. I have looked into

sp_spaceused
sp_helpdb (<databasename>)
DBCC SQLPERF (LOGSPACE)

each of these gives the values in different units that don't add up thanks to the rounding of the values.

Thanks for your time.

 

[coni]

should be able to get this information from running the utilities from enterprise. Also SQL has books online.

 

[MikeSchall]

I'm sorry, I didn't specify, but this needs to be through code, so Enterprise Manager is not a possiblity.

 

[Cagliostro]

Try to find wich data in wich tables is stored. The mostly information you can find in master's db table. John Fill