Re: Created 15,000 tickets

[Nall, Roger]

Title: RE: Created 15,000 tickets

** Kathy,   I am sure this will be just one of many recommendations to not try to renumber your existing tickets using sql. There are way too many pitfalls. James’ suggestion to export out your current tickets, change your next ID value, and import while creating new IDs is the best course of action.   Good luck.   Roger A. Nall OSSNMS Sr. Remedy Administrator/Developer T-Mobile USA Desk: 973-644-3963 Cell: 973-652-6723 FAX: 973-267-6628 sf49fanv     AIM IM RogerNall   Yahoo IM   From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Wednesday, September 06, 2006 5:12 PM To: arslist@ARSLIST.ORG Subject: Re: Created 15,000 tickets   Kathy:   It is possible to do this but I don't have the knowledge on how to do this in the database, but I have done this through an export/import.  Just set the import tool to gen new id's.   James McKenzie   ________________________________ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Wednesday, September 06, 2006 2:06 PM To: arslist@ARSLIST.ORG Subject: Re: Created 15,000 tickets   ** Yikes!!  This is alarming.  Your advice regarding the "tickets created after the auto-generated tickets"  -- can the new tickets created today be renumbered directly in the database? __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___