Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raddy
Starting Member
12 Posts |
 Posted - 2008-06-05 : 11:23:13
|
| Hi, I know I can check individual table's properties for the size and row count of each, but is there a way of doing it for all tables within a database in SQL server 2005 ? I have about 69 tables in one.. Thanks,Raddy |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-05 : 11:27:06
|
| Run this in your database:EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'" |
 |
|
|
raddy
Starting Member
12 Posts |
Posted - 2008-06-05 : 11:27:44
|
| WOW! Thank you! :) |
|
|
|
|
|
|
Size of Tables