We have several legacy files that follow a numbering scheme but are not necessarily in order. I want to change the next document number value instead (ex instead of 00010, I want it to be 00100). All the documentation points at how to CREATE a sequence, but not change it. Does anyone know how to set the value for the sequence after the table as been created?
Each sequence has it's own table:
Each table has a column with a seed value. This is the starting sequence number.
Changing the next number requires changing this seed value:
DBCC CHECKIDENT('<sequence name>', RESEED, <desired start number value minus 1>);
PTC has also documented this in the knowledge base:
https://www.ptc.com/en/support/article/CS153950
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.