• Also,the two indexes on the table are dropped at the start of the SP, and recreated in a further step.

    It gets past the drop index, and truncate easily (we have a debug system in place, so i know where it gets to in the SP)