ok here's what I did to delete tickets.
from database scripts:
//delete tickets
delete from htblticket;
//then reset ticket # to begin at 1000
DBCC CHECKIDENT (htblticket, RESEED, 1000)
so far so working, going to re-import and attempt all ticket notes / comments
