getting tables size

Hi,
is there a method of getting table current size?
TIA!!Hi
Have you looked at sp_spaceused ?
John
"z. f." wrote:

> Hi,
> is there a method of getting table current size?
> TIA!!
>
>|||thanks!
is there a sample of using it in a loop for getting all tables information?
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message news:A7ABF
B91-352A-4816-8601-51CAA844C8AC@.microsoft.com...
Hi
Have you looked at sp_spaceused ?
John
"z. f." wrote:

> Hi,
>
> is there a method of getting table current size?
>
> TIA!!
>
>
>|||You could use Nigel's script:
http://www.nigelrivett.net/SQLAdmin...edAllTables.htm
l
Rgds,
Paul Ibison (SQL Server MVP)|||select object_name(id) as 'Table', used from sysindexes
Madhivanan|||sp_MSForEachtable 'sp_spaceused ''?'''
--
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"z. f." <zigi@.info-scopeREMSPAM.co.il> wrote in message news:OEDE0hjHFHA.297
6@.TK2MSFTNGP15.phx.gbl...
thanks!
is there a sample of using it in a loop for getting all tables information?
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message news:A7ABF
B91-352A-4816-8601-51CAA844C8AC@.microsoft.com...
Hi
Have you looked at sp_spaceused ?
John
"z. f." wrote:

> Hi,
>
> is there a method of getting table current size?
>
> TIA!!
>
>
>|||Try my stored procedure, that lists the sizes of all tables or top n tables:
http://vyaskn.tripod.com/sp_show_biggest_tables.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"z. f." <zigi@.info-scopeREMSPAM.co.il> wrote in message news:u8JdQ$iHFHA.333
2@.TK2MSFTNGP15.phx.gbl...
Hi,
is there a method of getting table current size?
TIA!!