I know this is not best practice. With that caveat, I am trying to add a segment to the front of our GL numbers globally. I am working in our test environment and while I can easily write the update statements, the foreign key constraints are myriad. Has anyone done a stored procedure or written other scripting to drop the foreign keys, make the changes, and re-create the foreign keys?
Well, I went ahead and finished this little project. There were 10 foreign keys to drop, update the GL and then re-create the keys. Let me know if anyone is interested in the script. Testing went well and I don't foresee any complications with it.