Query to return individual table sizes of all tables in a DB

Hi
Is there a query that can do this?
Regards
Sarah
Mark,
there are loads of scripts out there to do this, mostly based on
sp_spaceused eg here's mine:
http://www.replicationanswers.com/Downloads/MonitoringSizes.txt.
BTW if you just want a visual report, the "Table Info" section of "Task
Manager" in SQL Server 2000 will show this detail.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Query to return individual table sizes of all tables in a DB

Hi
Is there a query that can do this?
Regards
SarahMark,
there are loads of scripts out there to do this, mostly based on
sp_spaceused eg here's mine:
http://www.replicationanswers.com/Downloads/MonitoringSizes.txt.
BTW if you just want a visual report, the "Table Info" section of "Task
Manager" in SQL Server 2000 will show this detail.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Query to return individual table sizes of all tables in a DB

Hi
Is there a query that can do this?
Regards
SarahMark,
there are loads of scripts out there to do this, mostly based on
sp_spaceused eg here's mine:
http://www.replicationanswers.com/D...oringSizes.txt.
BTW if you just want a visual report, the "Table Info" section of "Task
Manager" in SQL Server 2000 will show this detail.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

query to give me db sizes

Id like to have a query that gives me the all the total db data sizes such
as
DB1 100GB
DB2 25GBHassan,
This will give you some of the information you want:
exec sp_MSforeachdb N'exec ?..sp_spaceused'
Note that sp_MSforeachdb is undocumented and unsupported. Do
not use it in production code. Details about the system stored procedure
sp_spaceused can be found in Books Online.
Steve Kass
Drew University
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23pg5sXlXFHA.2540@.tk2msftngp13.phx.gbl...
> Id like to have a query that gives me the all the total db data sizes such
> as
> DB1 100GB
> DB2 25GB
>|||Hi,
Execute the below stored procedure from Query analyzer.
sp_databases
Thanks
Hari
SQL Server MVP
"Steve Kass" <skass@.drew.edu> wrote in message
news:OaOELKoXFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Hassan,
> This will give you some of the information you want:
> exec sp_MSforeachdb N'exec ?..sp_spaceused'
> Note that sp_MSforeachdb is undocumented and unsupported. Do
> not use it in production code. Details about the system stored procedure
> sp_spaceused can be found in Books Online.
> Steve Kass
> Drew University
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:%23pg5sXlXFHA.2540@.tk2msftngp13.phx.gbl...
>

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