>Didn't know that. Was there any kind of limitations mentioned as to number of records involved or number of indexes? Seems like a lot more temporary work space would be needed if you were reindexing a very large table with a lot of indexes. I thought this was one reason that it only made one pass at a time for each index.
They didn't mention anything. I haven't dealt with really large tables for several years.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer