SQL Server Performance Forum – Threads Archive
Table Size ReportHello All, I need to produce a report that lists tables by their size with information about their
indexes. Are there any sprocs that do this kind of work? Thanks,
SP_SPACEUSED @Updateusage=’true’ _________
In addition to what satya had told for table size, For report about their indexes go through the text of sp_help in master database. Gaurav
And SP_HELPINDEX too for additional information.
Thanks for that information