Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to see size of each table
Message
De
27/07/2010 10:24:49
Naomi Nosonovsky
Wisconsin, États-Unis
 
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Titre:
Re: How to see size of each table
Divers
Thread ID:
01474138
Message ID:
01474141
Vues:
64
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform