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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"