Starting ticket # for helpdesk

[AEMIT]

Howdy,

To save us some reporting headaches/overlap/confusion etc... we'd like to start the ticket # at say 9000

I found the article on how to reset it, but was not able to figure out how to go the opposite direction.

Any ideas?

Thanks!

[Esben_D]

I honestly would not know other than to create 9000 fake tickets with a script, delete them and then continue.

[AEMIT · Accepted solution]

Esben.D wrote:
I honestly would not know other than to create 9000 fake tickets with a script, delete them and then continue.

Thanks! While searching this I stumbled upon this result which I was able to use:
https://www.lansweeper.com/forum/yaf_postsm47398findlastpost_deleting-all-imported-tickets.aspx#post47398

If the link goes away

[This easily clears out the existing tickets]
delete from htblticket;

[I changed the value from 1000 to 9000 to start at the desired #]
DBCC CHECKINDENT (htblticket, RESEED, 9000)