Hi
The ITSM suite handles cascading deletes quite well, removing all related items when you delete the main incident case. We use it all the time to remove test cases from the production system when we introduce new customers. Stuart Schon Team Leader Delivery Services | Advanced Support | Remedy Solutions | KAZ Group Pty Ltd From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jorge Polo Sent: Thursday, 2 April 2009 5:03 AM To: arslist@ARSLIST.ORG Subject: Deleting Test Data for the ITSM 7.x Suite of Applications and Resetting Ticket IDs - ** Hello everyone, Could anyone give me an idea how difficult is to reset ticket id's in the Incident Management application version 7.1 ?....I know that after deleting the records in the main form I need to update the arschema table with the number I want to start. My problem is finding the cascade deletion for all the related tables .... how can I get all the tables related to HPD:Help desk form or the list of tables I need to update?.... We have a Microsoft Server environment and Microsoft SQL server database. AR System 7.1 Thank you..... Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"