Table Size

Hi,
Is there a way to get table size? I want to find out which tabel using the
most space. I saw there is a way to estimate the size with some formula and
calculation but i believe there must be some sp_ or other method to get the
exact and accurate table size.

TIA

Hi
sp_spaceused 'tablename'


"rupart" <rupart@discussions.microsoft.com> wrote in message
news:F14619ED-3A25-4161-BEEC- 6E89457C39DA@microso
ft.com...
> Hi,
> Is there a way to get table size? I want to find out which tabel using the
> most space. I saw there is a way to estimate the size with some formula
> and
> calculation but i believe there must be some sp_ or other method to get
> the
> exact and accurate table size.
>
> TIA

thx Uri,
I wonder why when i run this command, a dialog box prompting me to save the
report in .rpt format. Can't I view in the diplay pane?
I also find out i can check the table size in taskpad view :-)

"Uri Dimant" wrote:

> Hi
> sp_spaceused 'tablename'
>
>
> "rupart" <rupart@discussions.microsoft.com> wrote in message
> news:F14619ED-3A25-4161-BEEC- 6E89457C39DA@microso
ft.com... 
>
>
>

Hit "CTRL+D" in Quer Analyzer to get the result in display grid. Currently
your option is set for file  output(CTRL+SHIFT+F)
.

Thanks,
Sree

"rupart" wrote:

> thx Uri,
> I wonder why when i run this command, a dialog box prompting me to save th
e
> report in .rpt format. Can't I view in the diplay pane?
> I also find out i can check the table size in taskpad view :-)
>
> "Uri Dimant" wrote:
> 

yeah...my mistake!
tq guys!

"Sreejith G" wrote:

> Hit "CTRL+D" in Quer Analyzer to get the result in display grid. Currently
> your option is set for file  output(CTRL+SHIFT+F)
.
>
> Thanks,
> Sree
>
> "rupart" wrote:
>