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.

Did you enter data that filled all variable length fields completely? Remember: Amit's code estimates the size of the table based on every variable length field being completely filled in. So, if a variable length field is varchar(200), his script will estimate the size based on that field being completely filled with 200 characters versus, let's say, only 10.

Hossam AlFraih (12/2/2009)

Hossam AlFraih (6/19/2009)Hi Amit,

I used the script on one of my tables it gives me about 600 MB for 400,000 records.I filled that table with "actual" data (400,000 records) and It is only 150 MB!

Note: There were one clustered index (PK) and 4 non-clustered indexes in that table.