Hi, What database are you using?
MySQL: truncate table Tickets; truncate table Transactions; truncate table ObjectCustomFieldValues; truncate table Attachments. Other Databeses, I don't know. Please note that truncate is a dangerous command, and literally deletes all information in the tables selected, and resets the cardinality to 0. On Tue, Feb 9, 2010 at 11:01, softouch <razz...@hotmail.com> wrote: > > Is there any one who can help me to reset the ticket counter to 0. as i > have > deleted all test mails from dB so i also want to reset the thicket counter. > which table contains information about ticket counter? > -- > View this message in context: > http://old.nabble.com/How-to-reset-ticket---counter-tp27520320p27520320.html > Sent from the Request Tracker - User mailing list archive at Nabble.com. > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > 2010 RT Training Sessions! > San Francisco, CA, USA - Feb 22 & 23 > Dublin, Ireland - Mar 15 & 16 > Boston, MA, USA - April 5 & 6 > Washington DC, USA - Oct 25 & 26 > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Bill Graboyes On Assignment At: Toyota Motor Sales, USA, Inc. Consumer Portal Delivery Office: (310) 468-6754 Cell: (714) 515-8312
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
