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 |
|
tup
Starting Member
13 Posts |
 Posted - 2003-08-20 : 04:48:48
|
| Hi,I'm very new to Sql so please forgive me for my stupidity.I want to find out the size of one certain table but I just don't know how(the table is in database BPB) ,I'm doing this for my high school magazine so please help otherwise I'll be kicked out from the magazine team .Thanks |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2003-08-20 : 05:00:55
|
Maybe sp_spaceused 'table_name' will help you  If you are on SQL2K you can right-click on the db in question -> View -> Taskpad and then on the right pane jump to the 'Table Info' tab and search for your tableCheers,Frank |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-08-20 : 05:04:03
|
| do a forum search for 'table size' (exact match) and several links will show up....including this one.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=24018 |
|
|
|
tup
Starting Member
13 Posts |
Posted - 2003-08-20 : 05:07:28
|
| Thanks guys .You really helped me a lot.Back to work.Cheers |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-08-20 : 07:14:56
|
| A good friend of mine wrote this little proc which will tell you the space used for every user table in your database.Jay White{0} |
|
|
|
|
|
|
size of the table