|Folder HelpDesk||Database||Is there a way to change the start number of the ticket IDs without creating dummy tickets?|
Is there a way to change the start number of the ticket IDs without creating dummy tickets?
Yes, it is possible to change the ticket ID start number, and there are two ways to do this.
In the descriptions below the ticket numbers start from 1000, but you can follow the same steps for any serial number you wish to start with.
Start SQL Server Management Studio.
Open tblTickets in design mode.
Select the column intTicketID.
Set the Identity Seed property to 1000.
Save the table design changes.
A quicker solution is to just run the following command in the SQL Query window for the database used with Folder HelpDesk:
DBCC CHECKIDENT (‘[tblTickets]’, RESEED, 1000)