Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to see size of each table
Message
From
27/07/2010 10:24:49
Naomi Nosonovsky
Wisconsin, United States
 
General information
Forum:
ASP.NET
Category:
Databases
Title:
Re: How to see size of each table
Miscellaneous
Thread ID:
01474138
Message ID:
01474141
Views:
65
>Hi.
>I am going over the 4 gig limit on SQL Express but am not sure which table(s) is causing this. Is there a way in SSMS to see the sixe of each table ?
>TIA
>Gerard

Try this quick script
exec sp_MSforeachtable 'print ''?'' exec sp_spaceused ''?'''
Check also http://www.4guysfromrolla.com/webtech/032906-1.shtml
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform