SQL server express 2005 help

[Jono]

Hi,

Any (easy) way to find the size on disk of a database as a whole, and then each of its tables?

Cheers,

 

[TrUz]

If you right click on the database and select Properties it will tell you the size of the database. Not sure how you can find out the size of each individual table... Maybe there is a system Stored Procedure, not sure.

EDIT: Turns out there is a Stored Procedure: exec sp_spaceused <tablename>

Not sure if express will come with this though. Give it a go.

TrUz

 

[Jono]

Ah cheers