SQL 7 DB Sizing Query

[CDuffy]

I have a lot of DB in various Customers places and I have to check if there is a pattern in the size of the tables and indexes to be able to create a sizing tool for the future DB I will have to create.
I need a query to extract from my DB,
- the table name,
- size of the table,
- size of space really use in the table,
- indexes name related to those tables
- and the size of the indexes.

I am using SQL 7 on NT 4 Servers.

 

[Cagliostro]

all this information is stored in different tables in master db. John Fill