Written by:R Teachout
1/7/2008 6:27 PM

Just open query analyzer (or SSMS->query) and run the following against a database:

EXEC sp_MSforeachtable "exec sp_spaceused '?'"

This returns s list of tables, and the amount of usage they are using (rows + data usage)

TrackbackPrint

Location: BlogsRamblings, Scriptlets, and more!MSSQL Scriptlets

Your name:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel