How to retrieve reserved DB data & log space

[zedios]

Hello all

I need a way to retrieve the space that is reserved for data and log space
in a DB.

I have tried using DBname.owner.sysfiles and the calculating the space but
it seems that this doesn't yield the same result as is shown in Interprise
manager.

Any tip will be greatly appreciated!!

[Michael Levy]

Does sp_helpdb give you the information you want?

-Mike
--
Michael Levy MCDBA, MCSD, MCT
michaell@gasullivan.com