Rami,
If you have access to the database directly, look for the ARSCHEMA
table and update the value for NEXTID for the table in question. If you
have any records in the Incident table and you set the NEXTID below the
existing entry IDs, you will have problems later when the NEXTID value
increments to equal the existing entry id.
Bruce
_____
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rami S Ayoub
Sent: Monday, July 16, 2007 5:38 AM
To: [email protected]
Subject: Reset Incident Number ID
**
**
Hi List,
How can I Reset the IN Number to start from IN00000000000001., i already
have old cases and i want now start from number 1 ?
AR Server 7
SQL 2005
Incident and Problem
Windows 2003
Regards,
Rami
__20060125_______________________This posting was submitted with HTML in
it___
#####################################################################################
The information contained in this electronic mail message, including
attachments, if any, is PetSmart confidential information. It is intended only
for the use of the person(s) named above. If the reader of this message is not
the intended recipient, or has received this message in error, you are hereby
notified that any review, dissemination, distribution or copying of this
communication is strictly prohibited. If you are not the intended recipient or
have received this message in error, please notify the sender via e-mail and
promptly delete the original message.
#####################################################################################
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
