Hi All, Can some one help me that how can i find the size the index. Also Can some one have the script that will give me all the indexes and their sizes..

Thanks

In sql 2000, SQL server stores indexes information in system table i.e. sysindexes.

Youy can query above table to get all the names of indexes and size of the index.

size can be retrived as dpages*8 K