This is a useful script I use to list the space used for all databases on a given sql server

EXEC sp_msforeachdb @command1="use ? exec sp_spaceused @updateusage = N'TRUE';"

The purpose of passing the argument : @updateusage , is it updates the usage information

Author: Jack Vamvas