Wednesday, March 21, 2012

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 .

No comments:

Post a Comment