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...

quote:

---

> 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...

quote:

---

> 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...

quote:

---

> hi
> sp_spaceused 'table'
> Note: It may provide inaccurate output ,therefore try to update

---

statistics.

quote:

---

>
> "cyshang" <anonymous@.discussions.microsoft.com> wrote in message
> news:50CC941F-24D0-46DC-905C-93521419A6D8@.microsoft.com...
>

---

sql