Reset ticket starting number

Question:

How can you change the ticket starting number on the self-hosted version? E.g., rather than 6,7,8,9,10…. For the next few tickets I would prefer 15106, 15107, 15108, 15109, 15110.

Answer:

You can achieve that by running this command

DBCC checkident ('hdIssues', reseed, 1000)

at your SQL server, against the helpdesk database