I believe it would be:
UPDATE arschema SET nextId=<value> WHERE name='<schema name>'; From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tommy Morris Sent: Friday, September 17, 2010 10:39 AM To: arslist@ARSLIST.ORG Subject: Reset NextID ** I cannot remember for the life of me, how do you reset the NextID numbers in Remedy 7.5? We are migrating from Remedy 5.5 to AR7.5 ITSM 7.6 and I need to bump the PR and PO numbers to start at current system number +1000. Tommy Morris RSTS Remedy Developer 817-415-6898 _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"