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:A7ABFB91-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/...dAllTables.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.2976@.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:A7ABFB91-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.3332@.TK2MSFTNGP15.phx.gbl...
Hi,
is there a method of getting table current size?
TIA!!