Received: from smtp.nwlink.com (smtp.nwlink.com [209.20.130.57]) by hub.org (8.10.1/8.10.1) with ESMTP id e7LNJET01793 for ; Mon, 21 Aug 2000 19:19:14 -0400 (EDT) Received: from anon (ip124.usw1.rb1.pdx.nwlink.com [207.202.132.124]) by smtp.nwlink.com (8.9.3/8.9.1) with SMTP id QAA03465 for ; Mon, 21 Aug 2000 16:19:12 -0700 (PDT) Message-ID: <005401c00bc6$764d9540$7c84cacf@nwlink.com> From: "jason watkins" To: Subject: copy DELETES to audit table Date: Mon, 21 Aug 2000 16:20:48 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 X-Archive-Number: 200008/213 I'd like to have a trigger that does something like serialize any row to a text string, then copys it into an audit table befor allowing the delete... having an restore function that can deserialize would be nice as well, but not criticle.. the goal would be to allow a couple people who need the ability to remove rows the ability to do so, but to not loose the information for a week or so, so that the choice can be double checked by someone else. jason watkins