Try Copying the records which u don't want to delete into another temporary table. Then Truncate the original table & then copy the records from temporary table to the original...