The good news: we have to do it too The bad news: We're moving to a new server and we're just going to do it as part of the migration in the Export Data/Search-Replace/Import fashion.
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jase Brandon Sent: Wednesday, February 20, 2008 4:24 PM To: [email protected] Subject: Changing Company Name on 7.0.01 ** Hello All, I am getting several requests to change the Company field in version 7.0.01 Ex. Joe's Computers is now changing it's name to Joseph's Computers. Field ID 1000000001. When I search this field ID in ARutilities, it returns 417 references to that field. Has anyone come up with a way to change Company name and ensure it is propogated throughout the database? Other than a monster SQL script to update the field in all locations, I don't think this is possible. My current answer to this question is: Set Joe's computers to "Obsolete" and recreate as "Joseph's Computers". But then we lost historical reporting data, etc. Has anyone else encountered this? I just thought we couldn't possibly be the only company who has dealt with this situation. 7.0.01 Unpatched SQL Server 2005 Thanks, Jase __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"
