Thanks very much Zack.

You mean SWITCH really works that fast? That will be great.

The table I am refering to is mostly used for reporting anyway, we just need to manage the size to improve performance. Another scenario, what if I want the history table in another instance on another host. That is, I do not want to create a new table on the live instance. Is it feasible to use maybe linked servers to acheive this. What other options?

In addtion, the SWITCH command assumes my production table is partitioned, right? I may not be allowed (by the consultant) to partition this table and thats the big challenge.