DBCC DBREINDEX in MS SQL 2000 requires large amount of free transaction file space. When I ran with Full Recovery mode, it needed about 100% of the size of the table to complete. I tested the same with MS SQL 7 and log space requirement was very low. Has the logging for index creation changed between MS SQL 7 and 2000? Any link to document on this will be highly appreciated.