Getting Help on Space Usage

To see the names, sizes, and usage of device fragments already in use by a database, execute sp_helpdb dbname. To see how much space the current database is using, execute sp_spaceused.