Reset NextID

2010-09-17 Thread Tommy Morris
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

Re: Reset NextID

2010-09-17 Thread Roger Justice
ARschema table NextID field. -Original Message- From: Tommy Morris tommy.mor...@radioshack.com To: arslist arslist@ARSLIST.ORG Sent: Fri, Sep 17, 2010 10:39 am Subject: Reset NextID ** I cannot remember for the life of me, how do you reset the NextID numbers in Remedy 7.5? We

Re: Reset NextID

2010-09-17 Thread Reiser, John J
] On Behalf Of Roger Justice Sent: Friday, September 17, 2010 10:41 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Reset NextID ** ARschema table NextID field. -Original Message- From: Tommy Morris tommy.mor...@radioshack.com To: arslist arslist@ARSLIST.ORG Sent: Fri, Sep 17, 2010 10:39

Re: Reset NextID

2010-09-17 Thread Wallace, Kelvin
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

Re: Reset NextID

2010-09-17 Thread David Sanders
://www.westoverconsulting.co.uk/ http://www.westoverconsulting.co.uk _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Reiser, John J Sent: Friday, September 17, 2010 3:53 PM To: arslist@ARSLIST.ORG Subject: Re: Reset NextID There was a form and few

Re: Reset NextID - resolved

2010-09-17 Thread Tommy Morris
Thank you. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Wallace, Kelvin Sent: Friday, September 17, 2010 9:52 AM To: arslist@ARSLIST.ORG Subject: Re: Reset NextID ** I believe it would be: UPDATE arschema SET nextId=value WHERE name