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

sskris · #1 (**permalink**) 03-09-06, 18:08

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

pdreyer · #2 (**permalink**) 03-10-06, 02:06

Check 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)

pootle flump · #3 (**permalink**) 03-10-06, 05:13

I was looking at this the other day.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62722

Internet Services

Web Development

Digital Marketing

Consumer Tech