Sure you can!
Take a look at sp_spaceused in BOL. I would also search the script section here. This will surely return several useful hits.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]