I will start reading up on indexes with partitions. On the brighter side... I have convinced the DBA's here to start working up a plan to migrate to '08.

Thank you again for all your time today.