Hi Oleg,

What about

SELECT INTO #TEMPTABLE
for the 10000 or so

DROP TABLE

SELECT INTO FROM #TEMPTABLE

Create index

Cheers,

Andrew

>Mark,
>These records expire 3 month after their "mail" day and it means all 1 million rec (minus 10,000 that were used) expire at once.
>So, for 2 weeks this "delete job" will do nothing, then it will try to delete 1 mln rec.
>I know severeal workarounds (including my BCP-Fox solution), it is beyond the scope of this thread.
>Let us just assume you must delete 1 mil rec from 4 mil and you never heard about Foxpro (and BCP?).
>The question is how you delete 1 mil rec?
>Anybody has this experience?
>Thanks
>Oleg