查询表占用空间

exec sp_MSforeachtable 'cranedata'
exec sp_spaceused 'cranedata20101227'
exec sp_MSforeachtable "exec sp_spaceused '?'"