Hello all, I looked thru the arslist to see how this was done. What I found is that it says to set the "nextid" field to 1 in the arschema table where name = "HPD:Help Desk".
However I don't want to reset the Request ID field, just the Incident ID field. I also want to do the same on Problem, Change and Tasks. We've been testing on a new prod box and are ready to go live this weekend and we want all app ID's set back to 1 before I start importing legacy records. Has this been done by anyone? Solaris Oracle 10.2g ARS 7.0.01 patch 4 Thanks!!!! Mary Dollus _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

