size of db

[Bell1991]

Is there a query i can run to find out the size of a database?

I want to find out the size of all my databases and rather than go one by one and click on properties - this would be a lot faster.

Thanks

 

[icemel]

sp_helpdb

 

[Bell1991]

Thanks

 

[SQLBill]

sp_spaceused also works.

There is also a FAQ in this forum that describes an 'undocumented procedure' which will let you run one command against all databases. Check it out and look for MSForEachDB

-SQLBill

Posting advice: FAQ481-4875

 

[TysonLPrice]

Something I saw somewhere..

SELECT name AS NameOfFile,
size/128.0 -CAST(FILEPROPERTY(name, 'SpaceUsed' )AS int)/128.0 AS AvailableSpaceInMB
FROM dbo.SYSFILES

If the DBs are linked you could run it from one spot.