Here's a link to a similar query I published in June.

http://www.sqlservercentral.com/scripts/99716/[/url]

For contrast, that one was attempting to stay as close to the original sp_spaceused results as possible, whereas this new one throws in some extra metadata. That's to say, Barry's version is more customized instead of trying to be super-exact.

My main recommendation would be to put an ORDER BY clause in there. I also notice that this script won't show some user objects that take up space, like an indexed view.

Thanks for sharing!