How to get the size of a table

Hi
Have anyone know how to get the info. of the size of s table?EXEC sp_spaceused <table name>
--
Jacco Schalkwijk
SQL Server MVP
"cyshang" <anonymous@.discussions.microsoft.com> wrote in message
news:50CC941F-24D0-46DC-905C-93521419A6D8@.microsoft.com...
> Hi,
> Have anyone know how to get the info. of the size of s table?|||hi
sp_spaceused 'table'
Note: It may provide inaccurate output ,therefore try to update statistics.
"cyshang" <anonymous@.discussions.microsoft.com> wrote in message
news:50CC941F-24D0-46DC-905C-93521419A6D8@.microsoft.com...
> Hi,
> Have anyone know how to get the info. of the size of s table?|||To add to Uri's, you can run
"sp_spaceused tablename, true"
command to update the stats and get the size for the table
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OkgIhrz3DHA.360@.TK2MSFTNGP12.phx.gbl...
> hi
> sp_spaceused 'table'
> Note: It may provide inaccurate output ,therefore try to update
statistics.
>
> "cyshang" <anonymous@.discussions.microsoft.com> wrote in message
> news:50CC941F-24D0-46DC-905C-93521419A6D8@.microsoft.com...
> > Hi,
> > Have anyone know how to get the info. of the size of s table?
>|||A quick way is to open Enterprise Manager, under View,
click taskpad. On the right is a tab called tables. Open
and enter table name for details.
Don Saluga
>--Original Message--
>Hi,
> Have anyone know how to get the info. of the size of s
table?
>.
>