Check Table Size

Hello,
How can i check the size of one table ?
Best regardsTry sp_spaceused
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:fcda01c43e88$c17437b0$a001280a@.phx.gbl...
Hello,
How can i check the size of one table ?
Best regards|||Hi,
use dbname
go
sp_spaceused <table_name>
or
use <dbname>
go
sp_spaceused <table_name>, @.updateusage ='true'
@.updateusage will correct the inconsistencies in indexes and give you much
more perfected value.
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:fcda01c43e88$c17437b0$a001280a@.phx.gbl...
> Hello,
> How can i check the size of one table ?
> Best regards