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
Comments