i am using SQL65, when i use delete statement to delete records, i found my DB available space become smaller. I know this may be caused by delete action will use transaction log space, but i found that i can not truncate my DB transaction log. my db's log and data share with same db device. i try to use dump transaction log but seems no use, and i enable truncate log on checkpoint in my db option. is there any solution for i can truncate the log ? or i can delete record without logging into transaction log to avoid increase my db size?

Thanks a lot,