Thank you for pointing me in the right direction. I sincerely appreciate the knowledge.

Thanks for the quick response.

Since my only option is table partitioning, which is fine, can I partition the tables in SQL Server 2000?

Sorry, let me try to be more clear.

I want to create partitions on the whole data file not just individual partitions on the tables. I want to be able to...