Ron, I would think that any DBA should be able to get the job done. (And much faster than going through the ARS server.)
However, while you are at it... I would suggest that you change the length back to 15 so that you never have to do this again. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Fri, Sep 12, 2008 at 10:53 AM, Smith, Ron [TBC] <[EMAIL PROTECTED]> wrote: > ** > > Hi all, > Wanted to bounce this off the group to see if there is an easy and safe way > to increase the size of the Entry-ID Field (1). We are currently at a > length of six on the Homegrown helpdesk app, and after 10 + years using it, > we are about to roll over ID# 999999. What I want to do is to increase it > to a length of 8. Problem is that the existing ID's do not pad out to the > full 8 digits. Is there any utilities out there that makes this change easy > and simple to do. I am pretty sure I can do this by exporting the data and > massage it and reimport it, but looking for an easy way to do it. > > Thanks in advance. > > ARS 6.3 P.20 > Win 2K3 > SQL Server 2000 > > Thanks, > > Ron Smith > Remedy/Web Developer > Providence Health & Services OR > [EMAIL PROTECTED] > 503-216-7866 > > DISCLAIMER: > This message is intended for the sole use of the addressee, and may contain > information that is privileged, confidential and exempt from disclosure > under applicable law. If you are not the addressee you are hereby notified > that you may not use, copy, disclose, or distribute to anyone the message or > any information contained in the message. If you have received this message > in error, please immediately advise the sender by reply email and delete > this message. > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"