query to give all table sizes on a database (was "query help")

Hi,
Does anyone has query to give all table sizes on a database?
Appreciate your help.
ThanksCheck sp_spaceused

Take the output from:
select 'exec sp_spaceused '+name from sysobjects where type='U'

and execute it on your database (assuming statistics is up to date)|||I was looking at this the other day.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62722