Exactly, dropping the triggers is something I'd like to avoid. I'd much rather copy and then "fix" in the new account. I was hoping there were commands to facilitate (similar to SET.INDEX for Indexes).
Thanks, Mark ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Boydell, Stuart Sent: Monday, June 01, 2009 8:09 PM To: U2 Users List Subject: Re: [U2] Triggers and Account Copy ...if it's a 24/7 file (ie you can't drop the trigger as it would compromise data integrity) you can edit the file header once it has been restored. It's fiddly but possible. We do it this way when using a snap copy of the production database.
_______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
