Hi,
While rebuilding the clustered indexes, we need free space on db which is equivalent to table size(As it has to rearrange all the pages). Do we have any stored procedure to check whether we have space available on db or not to re-create indexes(If we have calculation like how many pages/Bytes additionally required is also fine)? Can anybody help me?


Thanks In advance.

With Best Regards,
Naveen.

sp_spaceused <table_name>
will show you the current size of the table

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.

sp_helpdb <your_db>
will show you the free space in <your_db>
look at the code of sp_helpdb and sp_spaceused to develop your own code to calc the differential amount