space issues when you try to re-index

[ezecastle]

I'm trying to find out why when I try to reindex a table It fails because I dont have enough space in the data file where the index resides? I have over 2GB of free space but it still fails, why does this happen when you re-index?

Thanks for your time.

[skhanal]

You need at least same amount of space free as the total size of indexes.

How large is the index on the table?

[rmiao]

Allocate more space to the file if disk has free space.

[ezecastle]

ahh ok, some of the indexes are rather large. I will add space to the data files and see how that works.

thanks