Home >FAQ >Folder HelpDesk kalmstrom.com site map icon Site map  

kalmstrom.com FAQ – Folder HelpDesk


Type Database

Problem 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.

A
  1. Start SQL Server Management Studio.
  2. Open tblTickets in design mode.
  3. Select the column intTicketID.
  4. Set the Identity Seed property to 1000.
  5. Save the table design changes.
B
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)
Go

Products Buy FAQ Services Apps Tips Education Contact About Us Blog

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved