You are right sp_spaceused <Tablename>,1 will give us the detailed output about the table and their index sizes. But my concern here is i need to calculate the available db space now and differential amount of space needed to re-create index.