Hi Jeff,

I agree with you. That is a horrible design. I ran Friday using the following code in query analyzer. It ran for 1hr 14 min. for...

Thanks Matt for your reply.

I am actually trying the rowset option with a test database of 1 million records with rowset 1000. So far it has been running for...

The problem I am having is space and time on the sql2000 server. I need to know how to accomplish this without hogging the system.