deleting all imported tickets

[drtag8]

working on an import from spiceworks. I imported 8000 tickets without notes and now need to delete them.

any ideas where to start?

[drtag8]

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