Ticket id - Ticket Number - When i clear the database

V5 Question
1

Hi all!
I was wondering where is the ticket id number so i can start from 1.
I delete all the transactions with the query provided in the system.
When i start again, i see that the ticket number is 1 but the ticket ID is 15135

Captura.PNG870×143 5.8 KB

I need both of them to be in 1… but i cant find the table in the database that generate this value.

Is there a way to it? In which table is it?

Thanks a lot for your help.

Best Regards,

PS: The same thing happens with entities. I delete all the customers, and i want to start with ID 100 for example, but starts in 9000.

Thanks again!

2

Try this script BACKUP YOUR DATABASE FIRST.

DBCC CHECKIDENT (‘Tickets’, RESEED, 0);

2 Likes
3

Kendash,
Thanks a lot, Worked like a charm!
Regards