How to find out size of the individual databases i

Question

Please tell the query to find out size of the individual databases in the sql server 2005?

Answer 1

try this sp_spaceused

exec sp_spaceused

Answer 2

EXEC sp_MSforeachtable 'EXEC sp_spaceused [?]'