sql server 2000, how much a table weighs ? 1

[tempo1]

Hi everyone
In order to free disk space i need to identify tables and databases on the disk.
Can i know a table's size (in bytes, not rows !) and database's size through system files in the SQL SERVER ? Any other resource to learn about my databases size ?
Can anyone tell me what is the extension of a table/database on the disk ?
Thanks

 

[gmmastros]

In query analyzer, run:

[tt][blue]sp_helpfile[/blue][/tt]

This will tell you which files are associated with each database and what the size of the files are.

To get the size of each table, run this:

[tt][blue]sp_msforeachtable 'sp_spaceused [?]'[/blue][/tt]

-George

"the screen with the little boxes in the window." - Moron

 

[tempo1]

Thanks a lot George !

 

[gmmastros]

You're welcome, a lot!

-George

"the screen with the little boxes in the window." - Moron