Thanks Bruce, Resolved.
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Scott Sent: Monday, July 16, 2007 5:01 PM To: [email protected] Subject: Re: Reset Incident Number ID 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"
