Hi Amit,

Thanks a lot ! But when I executed this procedure its displaying 0 kb for clustered_index_size_in_kbytes, I tried for different tables which actually has clustered indexes but for all its displaying the same. Other than this its calculating all other parameters. I would appreciate your clarification.

Thanks,

Sam.