Index size 1

[Tekreader]

Can anyone tell me how to find the index size in table. Sp_spaceused will give me all the indexes space used in a table.But i want to find each index space used in a table in sql 2000.

Thanks

 

[PatriciaObreja]

Try sp_MSindexspace:

The sp_MSindexspace stored procedure returns the size in kb, of the indexes found in a particular table.

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium