SQL Server Performance Forum – Threads Archive

Table Size Report

Hello 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’ _________
Satya SKJ

---

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.
_________
Satya SKJ

---

Thanks for that information

---

]]>