This is for oracle but must be similar for sql
*Type this statement to update the id* update aradmin.arschema set nextId = *011848* where name = *'CHG:Change*'; commit; *Type this statement to find next ID* select name, nextId from aradmin.arschema where name = *'CHG:Change'*; Susan On Wed, Dec 17, 2008 at 8:10 AM, Timothy Rondeau < [email protected]> wrote: > Hi, > > Hoping someone can refresh my memory. I want to start a new form at a > higher request ID than 1. So say 1000, I know there is a command to do > this. > > We are on Windows 2003, SQL 2000. ars 7.0.1 > > Thanks > > Tim > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

