"Hassan" <fatima_ja@hotmail.com> wrote in message
news:%23pg5sXlXFHA.2540@tk2msftngp13.phx.gbl...
> Id like to have a query that gives me the all the total db data sizes such
> as
>
> DB1 100GB
> DB2 25GB
>
>

"Steve Kass" <skass@drew.edu> wrote in message
news:OaOELKoXFHA.2128@TK2MSFTNGP14.phx.gbl...
> Hassan,
>
> This will give you some of the information you want:
>
> exec sp_MSforeachdb N'exec ?..sp_spaceused'
>
> Note that sp_MSforeachdb is undocumented and unsupported. Do
> not use it in production code. Details about the system stored procedure
> sp_spaceused can be found in Books Online.
>
> Steve Kass
> Drew University
>
> "Hassan" <fatima_ja@hotmail.com> wrote in message
> news:%23pg5sXlXFHA.2540@tk2msftngp13.phx.gbl...
>> Id like to have a query that gives me the all the total db data sizes
>> such
>> as
>>
>> DB1 100GB
>> DB2 25GB
>>
>>
>
>