How do I get a list of table sizes in SQL Server

Use the command

EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"

Thanks to the 4guysfromrolla for this - for a fuller explaination see http://www.4guysfromrolla.com/webtech/032906-1.shtml