Sep 11
If you need to find the size of each table in the database here is an easy way.
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"
I use it to find those pesky tables that are hogging all my disk space. (Usually it's the log file though)
Source:
http://www.4guysfromrolla.com/webtech/032906-1.shtml
