Re: online engine use of disk space

Quoting BILLKURUC... } } try building a "clustered index" } this will get back space for Deleted rows without having to unload and } load } This is what I usually suggest however, I was recently reminded that you need to have the space available to hold both the old table and the new table simultaneously until the ALTER INDEX has finished. DAS -- Dave Snyder @ Bell Atlantic - Philadelphia, PA WORK: ddx85qr@boots.bell-atl.com HOME: dave@das13.snide.com